How to trace the errors in pl/sql block code?
Answer Posted / madhuri
SHOW ERROR will show the error code and message in a pl/sql
block.
If you know where exactly the error is then uses number of
dbms statements before/after each sql statement.
Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
How many subqueries can be nested in a statement?
Is it possible to include an insert statement on the same table to which the trigger is assigned?
What is #table in sql?
What is the difference between inner join and outer join?
What are triggers in sql?
What is primary key and foreign key?
What is the use of function in sql?
what is clause? : Sql dba
What is the use of %rowtype?
Explain the components of sql?
How run sql*plus commands that are stored in a local file?
Explain the difference between cursor declared in procedures and cursors declared in the package specification?
Why stored procedures are faster than query?
What are the parameter modes supported by pl/sql?
What is memory optimized table?