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
What is fmtonly in sql?
Why do we use procedures in sql?
Is it mandatory for the primary key to be given a value when a new record is inserted?
What is an alias command?
Does pl/sql support create command?
What are the different datatypes available in PL/SQL?
What are its different types of dbms?
what is cursor. write example of it. What are the attributes of cursor.
what is the difference between mysql_fetch_array and mysql_fetch_object? : Sql dba
What is a primary key? Explain
Why stored procedure is better than query?
What is not null in sql?
What is sql table?
What is a crud api?
What is database sql?