GeekInterview.com
  I am new, Sign me up!
 
GeekInterview.com  >  Interview Questions  >  Oracle  >  PL/SQL
Go To First  |  Previous Question  |  Next Question 
 PL/SQL  |  Question 95 of 241    Print  
how to trace the errors in pl/sql block code..

  
Total Answers and Comments: 4 Last Update: May 07, 2008     Asked by: rajanen 
  
 Sponsored Links

 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
July 25, 2006 08:26:24   
pankaj_gauba Member Since: November 2005   Contribution: 16    

RE: how to trace the errors in pl/sql block code..

User_Errors table

OR

show error on sql promt


 
Is this answer useful? Yes | No
August 14, 2006 06:43:26   
Sphurti        

RE: how to trace the errors in pl/sql block code..

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.


 
Is this answer useful? Yes | No
March 14, 2007 17:47:48   
pari        

RE: how to trace the errors in pl/sql block code..
the correct command is
SHOW ERRORS or
SHOW ERR

 
Is this answer useful? Yes | No
May 07, 2008 06:24:16   
krishnaindia2007 Member Since: September 2007   Contribution: 854    

RE: how to trace the errors in pl/sql block code..
You can use

USER_ERRORS
or
SHOW ERRORS

You may also use DBMS_OUTPUT.PUT_LINE

 
Is this answer useful? Yes | No


 
Go To Top


 Sponsored Links

 
About Us -  Privacy Policy -  Terms and Conditions -  Contact -  Ask Question -  Propose Category -  Site Updates 

Copyright © 2005 - 2010 GeekInterview.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape