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

is mysql query is case sensitive? : Sql dba

568


What are sql queries used for?

540


Does postgresql run on the cloud?

593


What are all types of user defined functions?

532


How many times can we commit in a loop?

570






how to install mysql? : Sql dba

582


What is a ddl command?

543


Explain select statements in sql?

593


How many scalar data types are supported in pl/sql?

530


Is postgresql a server?

577


What is inner join in sql?

588


What is the advantage of nosql?

531


What is the difference between cluster and non-cluster index?

624


What is trigger types of trigger?

556


Why do we use joins?

570