How do you debug PL/SQL code?



How do you debug PL/SQL code?..

Answer / samsudeen

When u execute the PL/SQL in putty u are using follwing
command

SQL > @samsu.sql

if not compile succeefully, u can use the follwing command
to debug the PLSQL.

SQL > show errors

its display the error name , line no and column no.

Is This Answer Correct ?    2 Yes 1 No

Post New Answer

More JDBC Interview Questions

Explain some new features available in jdbc 4.0?

0 Answers  


What is 2 phase commit?

0 Answers  


How to execute bulk number of queries at once?

3 Answers   Wipro,


What is preparedstatement in jdbc?

0 Answers  


Is it possible to connect to multiple databases simultaneously?

0 Answers  






What is the difference between Minus, and Intersect?

1 Answers  


How do I insert/update records with some of the columns having NULL value?

0 Answers  


Expalin the method of calling a stored procedure from jdbc.

0 Answers  


What is meant by jdbc?

0 Answers  


Does jdbc use odbc?

0 Answers  


If you are truncated using JDBC, how can you that how much data is truncated?

0 Answers  


Explain what should be done when a SQL exception is raised?

0 Answers  


Categories