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 sql in oracle?

1044

How many types of primary keys are there?

1019

how to get a list of all tables in a database? : Sql dba

954

Why are aggregate functions called so?

933

How many types of cursors are available in pl/sql?

1082

What are the disadvantages of file system?

1240

What is before trigger?

988

what is the difference between blob and text? : Sql dba

1002

what is 'mysqlimport'? : Sql dba

1018

Is join an inner join?

947

what is the use of set statement in tsql? : Transact sql

993

What is the benefit of foreign key?

1009

How to run sql functions in pl/sql?

1041

How do I make my sql query run faster?

919

How do I make sql search faster?

982