PL/SQL - Debug PL/SQL Code

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

Go To First | Previous Question | Next Question

PL/SQL | Question 231 of 237

Debug PL/SQL Code

How will you debug PL/SQL Code?

Total Answers and Comments: 3

Last Update: November 04, 2008 Asked by: chinnuchaitu

Sponsored Links

Best Rated Answer

—

Submitted by: aleemkh

Use "Show Errors" command on SQL Plus

Above answer was rated as good by the following members:
rajeshsingh9

August 10, 2008 05:15:23

aleemkh

Member Since: July 2008 Contribution: 18

RE: Debug PL/SQL Code

Use "Show Errors" command on SQL Plus

Is this answer useful? Yes | No

1 0

Overall Rating: +1

August 20, 2008 07:42:48

soujibb

Member Since: August 2008 Contribution: 1

RE: Debug PL/SQL Code

1. We can debug using toad, pl/sql developer tools. Debug option will be there in these tools. before debugging the package or anything, enable the dbms_output option.

or

2. Using DBMS_DEBUG Package also we can debug the pl/sql code.

Is this answer useful? Yes | No

November 04, 2008 18:01:53

Mad Hatter

Member Since: November 2008 Contribution: 6

RE: Debug PL/SQL Code

You can use variouse tools like Toad to debug PL/SQL package
Other way is to implement your own debug technic, like printing bms_output during the code execution (cons - you will get output only when package finished)
You can create debug package with pragma autonomos_transaction to log all your steps.
Also, if you need to check/tune your package performance, there is Oracle DBMS_PROFILER package. It was introduced in Oracle8i to allow developers to profile the run-time behaviour of PL/SQL code, making it easier to identify performance bottlenecks which can then be investigated more closely.

Is this answer useful? Yes | No

Go To Top