How to execute an oracle stored procedure? How to execute an oracle stored procedure? oracle oracle

How to execute an oracle stored procedure?


oracle plsql oracle10g ora-00900

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.)

oracle plsql oracle10g ora-00900

Oracle 10g Express Edition ships with Oracle Application Express (Apex) built-in. You're running this in its SQL Commands window, which doesn't support SQL*Plus syntax.

That doesn't matter, because (as you have discovered) the BEGIN...END syntax does work in Apex.

oracle plsql oracle10g ora-00900

Both 'is' and 'as' are valid syntax. Output is disabled by default. Try a procedure that also enables output...

create or replace procedure temp_proc isbegin  DBMS_OUTPUT.ENABLE(1000000);  DBMS_OUTPUT.PUT_LINE('Test');end;

...and call it in a PLSQL block...

begin  temp_proc;end;

...as SQL is non-procedural.

Recent Posts
How can I color dots in a xy scatterplot according to column value?
How to update a claim in ASP.NET Identity?
What does {0} mean when initializing an object?
Accessing members of items in a JSONArray with Java
How to log SQL statements in Spring Boot?
Powershell Get-WebSite name parameter is ignored
How to detect scroll to bottom of html element
Java synchronized method
How to test controllers with CodeIgniter?
Detect Visual Composer
Matplotlib: Specify format of floats for tick labels
Rails join a list of strings with commas and "and" before the last