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

1 User has rated as useful.
Login to rate this answer.
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.
Login to rate this answer.
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
Login to rate this answer.
srimanta sahoo
Answered On : Oct 4th, 2011
You can debug the procedure by writting following command :
alter procedure procedure name
debug ;

1 User has rated as useful.
Login to rate this answer.