I am running into an issue on iacademy3.oracle.com (APEX), when trying to create a stored procedure which has an UPDATE statement. Executing the creation script from either "SQL Commands" or "SQL Scripts" causes the web page to hang. Stored procedures with INSERT statements get created without a problem.
Here is an example of a script that fails:
create or replace procedure p_update_salary (
p_employee_id employees.employee_id%type,
p_salary employees.salary%type
)
as
begin
update employees set salary = p_salary
where employee_id = p_employee_id;
end;
Any ideas why this is happening?
Thanks.