How to execute an oracle stored procedure

Question

I am using oracle 10g express edition  It has a nice ui for db developers  But i am facing some problems executing stored procedures    Procedure   create or replace procedure temp proc is begin   DBMS OUTPUT PUT LINE  Test    end   it is created successfully  But when i execute   execute temp proc   it shows ORA-00900  invalid SQL statement   So help needed here

User · Answer

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.

User · Answer

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 is begin   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

User · Answer

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

User · Answer

I use oracle 12 and it tell me that if you need to invoke the procedure then use call keyword  In your case it should be   begin   call temp proc  end

User · Answer

Have you tried to correct the syntax like this    create or replace procedure temp proc AS begin   DBMS OUTPUT PUT LINE  Test    end

[oracle] How to execute an oracle stored procedure?

Examples related to oracle

Examples related to plsql

Examples related to oracle10g

Examples related to ora-00900