How to execute an oracle stored procedure?
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.)