PL/SQL - Debug Procedure

GeekInterview.com > Tech FAQs > PL/SQL

Go To First | Previous Question | Next Question

PL/SQL | Question 125 of 156

Debug Procedure

How to debug a procedure in SQL Prompt

Total Answers and Comments: 3

Last Update: April 18, 2008 Asked by: av_t66

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

January 10, 2008 04:55:20

saurabh4922

Member Since: January 2008 Contribution: 4

RE: 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

Is this answer useful? Yes | No

January 10, 2008 04:56:29

saurabh4922

Member Since: January 2008 Contribution: 4

RE: 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.

Is this answer useful? Yes | No

April 17, 2008 07:20:57

puneet.kush

Member Since: April 2008 Contribution: 1

RE: Debug Procedure

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

Is this answer useful? Yes | No

Go To Top