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 |
how can connection with oracle10g with java
What is namedparameterjdbctemplate?
What is CLOB and BLOB datatypes in JDBC?
How do I connect to jdbc?
In JDBC, All the API?s are interfaces? Where is the actual implementation?
How can I create a custom RowSetMetaData object from scratch?
What is jdbc odbc connection?
What is com mysql jdbc driver?
What is the advantage of namedparameterjdbctemplate?
How do you know which driver is connected to a database?
If you are given a choice to implement the code to either insert a record or update if already exist, which approach will you follow ?
What does setautocommit do?