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 |
What does the jdbc resultset interface?
What is resultsetmetadata?
Explain jdbc savepoint?
What type of drivers are used for web application?
Difference between Dirty, commited ,phantom,repeatable reads?
What are stored procedures? How to call them?
State the three different ways in which you can create a table?
What is difference between jdbc and odbc?
Explain the JDBC Architecture?
What is statement and preparedstatement in java?
What's the benefit for specifying constraints like not null, primary key explicitly instead of specifying it against the column ?
How can I write to the log used by DriverManager and JDBC drivers?