1

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?

Andreas Fester
  • 36,091
  • 7
  • 95
  • 123
aretai
  • 1,619
  • 6
  • 19
  • 30
  • 1
    Can you run the statement usin SQL*Plus or some other tool? Maybe APEX won't let you run `exec` like that. –  Jan 15 '12 at 17:03
  • And if you only have Apex try `begin adjust_salary(200,5); end;` to see what happens. – John Doyle Jan 16 '12 at 01:52

1 Answers1

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

Dan A.
  • 2,914
  • 18
  • 23