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 error ora-12154: tns:could not resolve the connect identifier specified?

1117

Does view store data in sql?

1032

what are the advantages and disadvantages of cascading style sheets? : Sql dba

1101

What is the difference between explicit and implicit cursors in oracle?

1108

Could you please provide oca (oracle 10g) dumps for my certification ?

5235

How do you update a sql procedure?

1086

How to return an array from java to pl/sql?

1175

What is difference between stored procedures and application procedures?

1059

Are dml statements autocommit?

1091

What do you understand by pl/sql records?

1058

What is the usage of when clause in trigger?

1087

What is sql and db2?

1048

How do temporal tables work?

1015

What is pivot table in sql?

1163

What is pls_integer in pl sql?

1149