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 an exception in PL/SQL? What are the two types of exceptions?

1303

Does view store data in sql?

953

Can you select everything, but 1 or 2 fields, without writer's cramp?

979

How do I clear the screen in sql plus?

1035

What port does sql server use?

1056

How can check sql version from command line?

1077

How can you get sql*loader to commit only at the end of the load file? : aql loader

1007

What is mdf ldf and ndf?

991

What is trigger in pl sql with examples?

1027

what is “go” in t-sql? : Transact sql

1102

How do you modify a trigger?

920

What is the purpose of a sql?

973

What are pl sql procedures?

1020

What is trigger and stored procedure in sql?

1027

What is normalization in a database?

1150