How do you debug PL/SQL code?

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

Give an example for getXXX method?

633


What is a statement?

654


Which interface is responsible for transaction management in jdbc?

532


When do we use execute method in java jdbc?

618


The new features of the JDBC 2.0 API, will be supported for JDBC-ODBC Bridge?

1760






How to set NULL values in JDBC PreparedStatement?

621


What is odbc and jdbc drivers?

546


What are the advantages of using preparedstatement in java?

620


Which is better jpa or jdbc?

591


What does the jdbc driver interface do?

627


Does jdbc use odbc?

578


What is ojvm used for?

650


Explain the difference between resultset and rowset in jdbc

611


What is resultset in jdbc with example?

567


What is the difference between jdbc and jndi?

574