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

What is meant by connection string?

0 Answers  


What is the role of jdbc drivermanager class?

0 Answers  


What is sqlwarning?

0 Answers  


While in CallableStatament using in the oracle my procedure is return no.of columns so in java how can i retrivbe the data and i wnat to view all data which is reetrive from my procedure

0 Answers   ADP,


What is a statement?

0 Answers  






Is jdbc open source?

0 Answers  


What type of drivers have you used?

1 Answers  


What are restrictions on triggers?

0 Answers  


What is jdbc odbc in java?

0 Answers  


How can you use preparedstatement in jdbc?

0 Answers  


What does Class.forName return?

8 Answers   IBM,


How to connect html page to database using jdbc?

0 Answers  


Categories