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 is rowset?
What is Type-2 Driver and when this driver is used?
Explain the sequence of steps to connect to the database?
Explain the difference between resultset and rowset in jdbc
How many ways can you update a result set?
Discuss the significances of jdbc.
What is the role of class.forname while loading drivers?
Is jdbc faster than hibernate?
Explain what should be done when a SQL exception is raised?
What is sqlwarning and discuss the procedure of retrieving warnings?
What is the function of drivermanager class?
How to find that, a row is updated or not?