Debug Procedure

I hope you want to display the errors that Stored Procedure has , for that you can use "SHOW ERROR" command.

This displays the various errors in your procedure with the line numbers.


SAURABH GARG
SAKSOFT

I hope you want to display the errors that Stored Procedure has , for that you can use "SHOW ERROR" command.

This displays the various errors in your procedure with the line numbers.

You can debug the procedure. Oracle gives a util programme DBMS_DEBUG by which you can debug a procedure.

the full detail you can see at
http://www.oracleutilities.com/wiki/index.php?title=Dbms_debug

and also you can find out the good material at
http://www.unix.org.ua/orelly/oracle/prog2/ch26_01.htm

plsss tell me if it works

You can debug the procedure by writting following command :
alter procedure procedure name
debug ;