Execute
is sql*plus syntax .. try wrapping your call in begin .. end like this:
begin
temp_proc;
end;
(Although Jeffrey says this doesn’t work in APEX .. but you’re trying to get this to run in SQLDeveloper .. try the ‘Run’ menu there.)
Execute
is sql*plus syntax .. try wrapping your call in begin .. end like this:
begin
temp_proc;
end;
(Although Jeffrey says this doesn’t work in APEX .. but you’re trying to get this to run in SQLDeveloper .. try the ‘Run’ menu there.)