| |
GeekInterview.com > Interview Questions > Oracle > PL/SQL
| Print | |
Question: Debug PL/SQL Code
Answer: How will you debug PL/SQL Code? |
| November 11, 2008 18:01:53 |
#3 |
| Mad Hatter |
Member Since: November 2008 Total Comments: 5 |
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. |
| |
Back To Question | |
