GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

  GeekInterview.com  >  Interview Questions  >  Oracle  >  PL/SQL

 Print  |  
Question:  Debug PL/SQL Code

Answer: How will you debug PL/SQL Code?


April 04, 2009 15:32:24 #5
 OraclePassport   Member Since: April 2009    Total Comments: 2 

RE: Debug PL/SQL Code
 
The Best way to debug is by using an AUTONOMOUS TRANSACTION. Create a dummy table and insert into the table using the AT. This wont affect the main code, but one could know which part of the code the execution has reached while the program is running itself.
     

 

Back To Question