Debug Procedure

How to debug a procedure in SQL Prompt

Questions by av_t66

Showing Answers 1 - 12 of 12 Answers

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

  • 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.

  Was this answer useful?  Yes

srimanta sahoo

  • Oct 4th, 2011
 

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

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions