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 to create a new table by selecting rows from another table in mysql? : Sql dba
How is data stored in sql?
What is dynamic query?
Are ddl triggers fired for ddl statements within a pl/sql code executed using the dbms.sql package?
What does plv msg allows you to do?
what is normalization? : Sql dba
what is self join and what is the requirement of self join? : Sql dba
Why we use join in sql?
What's the procedure?
What does t sql mean?
What is keys and its types?
What is self-join and what is the requirement of self-join?
What is composite data type in pl sql?
what is isam? : Sql dba
What is sql architecture?