saurabh4922

 Profile Answers by saurabh4922 

• Jan 10th, 2008

 

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

saurabh4922

 Profile Answers by saurabh4922 

• Jan 10th, 2008

 

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.

puneet.kush

 Profile Answers by puneet.kush 

• Apr 17th, 2008

 

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

srimanta sahoo

• Oct 4th, 2011

 

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