PLSQL procedure execution error invalid statement

Question

I'm following a tutorial on PL/SQL http://www.plsqltutorial.com/plsql-procedure/. I have created procedure with the following code on apex:

CREATE OR REPLACE PROCEDURE adjust_salary(
    in_employee_id IN EMPLOYEES.EMPLOYEE_ID%TYPE,
    in_percent IN NUMBER
) IS
BEGIN
    UPDATE EMPLOYEES
    SET salary = salary + salary * in_percent / 100
    WHERE employee_id = in_employee_id;
END;

However when I try to run

exec adjust_salary(200,5);

I got error

ORA-00900: invalid SQL statement.

What is the problem and how to fix it?

Can you run the statement usin SQL*Plus or some other tool? Maybe APEX won't let you run exec like that. — user330315
– user330315, Commented Jan 15, 2012 at 17:03
And if you only have Apex try begin adjust_salary(200,5); end; to see what happens. — John Doyle
– John Doyle, Commented Jan 16, 2012 at 1:52

Dan A. · Accepted Answer · 2012-01-15 17:01:44Z

2

I see nothing wrong with your PL/SQL. You should check to see if the Procedural Option is installed:

http://www.techonthenet.com/oracle/errors/ora00900.php

answered Jan 15, 2012 at 17:01

Dan A.

2,92420 silver badges23 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

PLSQL procedure execution error invalid statement

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related