How to trace the errors in pl/sql block code?

Answer Posted / swapna

User_Errors table
OR
show error on sql promt.

Is This Answer Correct ?    7 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the two types of cursors in pl sql?

542


What is join view in sql?

515


what is the difference between truncate and delete statement? : Transact sql

552


What is the meaning of disabling a trigger?

649


What is clustered and nonclustered index in sql?

504






Why should I use postgresql?

566


What is the difference between delete, truncate and drop command?

554


Can we use ddl statements in stored procedure sql server?

520


What is the command used to fetch first 5 characters of the string?

889


How can triggers be used for the table auditing?

596


What is the primary key?

538


What are the different ddl commands in sql?

582


Name some usages of database trigger?

566


Can we group by two columns in sql?

507


What is execution plan in sql?

552