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 schema in sql example?
What are different types of functions in sql?
What are the benefits of pl/sql packages?
What are the methods of filing?
How do I write a sql query in pgadmin 4?
How to select 10 records from a table?
What is the life of an sql statement?
What are the types of triggers in sql?
How do you modify a trigger?
what is single byte over head in oracle..?
What is an inconsistent dependency?
What are dml commands?
what is 'mysqld'? : Sql dba
What are inner and outer joins examples of both?
what is normalization? : Sql dba