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


Please Help Members By Posting Answers For Below Questions

does sql support programming? : Sql dba

790


What is an exception in pl/sql?

722


What is an example of translating a date into julian format?

771


What is a left inner join?

703


what is a constraint? : Sql dba

878






Can we insert in view in sql?

770


What is user in sql?

759


What is a sql driver?

686


Which are the different types of indexes in sql?

741


What are the types of functions in sql?

740


what is a primary key? : Sql dba

737


How to Declare Fixed Length String Value In PL SQL

837


What is microsoft t sql?

674


Is pl sql a programming language?

712


What are two statement types in sql?

734