select text from user_errors where name='PROCEDURE NAME OR FUNCTION NA

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

Question Posted / shivashanker

Answer Posted / shivashanker

select text from user_errors where name='PROCEDURE NAME OR FUNCTION NAME'

Is This Answer Correct ?

2 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is a data manipulation language?

738

Enlist the data types that can be used in pl/sql?

741

What is difference between stored procedures and application procedures?

760

Which software is used for pl sql programming?

673

What is sql query optimization?

753

How do I trace sql profiler?

701

What are pl/sql cursors?

726

what is a composite key ? : Sql dba

793

Can we create a trigger on view?

662

How to return multiple rows from the stored procedure?

707

What is data abstraction in sql?

710

What are all the different normalization?

736

What is pl sql in oracle?

778

What is the reports view in oracle sql developer?

718

What is clustered index sql?

692