How to trace the errors in pl/sql block code..

Questions by rajanen   answers by rajanen

Showing Answers 1 - 4 of 4 Answers

Sphurti

  • Aug 14th, 2006
 

If you meant to check the logic then you can put some dbms statements within the PL/SQL block and then before executing it on prompt

Set serveroutput on

this command will print each dbms statements hence this will help to track where exactly the procedure is producing the wrong o/p.

  Was this answer useful?  Yes

pari

  • Mar 14th, 2007
 

the correct command is
SHOW ERRORS or
SHOW ERR

  Was this answer useful?  Yes

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