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

Can a composite key be null?

978

Is postgresql a nosql database?

1160

What are sql indexes?

999

What is the mutating table and constraining table?

1026

What is sql performance tuning?

918

Can a select statement fire a trigger?

1158

Why are sql stored procedures used?

1056

What are the types of records?

988

What is the difference between microsoft access and sql server?

1059

What is hibernate and its relation to sql?

1123

How many clustered indexes can be created on a table?

1075

What is the difference between joins?

1039

what are enums used for in mysql? : Sql dba

1170

What is sql engine in oracle?

989

How does index help in query performance?

1028