how to run proc in Oracle 10g
I have oracle 10G (GUI based-running in IE) .how do i compile and run proc code in it
Software/Hardware used:
Oracle 10g
Software/Hardware used:
Oracle 10g
ASKED:
August 13, 2009 9:03 PM
UPDATED:
December 7, 2011 5:58 AM
Answer Wiki:
To compile the proc, then run compile with procedure name and options. To run the procedure by running exec procedure command with passing variables.
systax for compilation
ALTER PROCEDURE [ schema. ]procedure
COMPILE
[ compiler_parameters_clause
[ compiler_parameters_clause ] ... ]
[ REUSE SETTINGS ] ;
e.g. Alter Procedure scott.sample Compile ;
To run procedure example,
Exec Sample;
To see all answers submitted to the Answer Wiki: View Answer History.
What edition of 10g are you using ? (enterprise, express, etc…)
CREATE PROCEDURE MyProc (ENO NUMBER)
AS
BEGIN
DELETE FROM EMP
WHERE EMPNO= ENO;
END;
this procedure program in not execute.so plz tell how to execute the proc in 10g oracel..