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 is sql*loader and what is it used for? : aql loader

618


What are the types of subqueries?

570


Why is pl sql needed?

507


how do you know the version of your mysql server? : Sql dba

503


What is file based approach?

487






Write a query to display the current date in sql?

511


Is primary key is clustered index?

527


i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this

1063


What is a data definition language?

552


What is hibernate and its relation to sql?

590


What is the use of function "module procedure" in pl/sql?

665


What is error ora-01000: maximum open cursors exceeded

598


Which command is used to delete a trigger?

771


What is sql in oracle?

623


What is sp_helptext?

586