SHOW ERROR will show the error code and message in a pl/sql block. If y

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

Question Posted / madhuri

5 Answers
16640 Views
TCS, I also Faced
E-Mail Answers

Answer Posted / madhuri

SHOW ERROR will show the error code and message in a pl/sql
block.

If you know where exactly the error is then uses number of
dbms statements before/after each sql statement.

Is This Answer Correct ?

5 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Can we use threading in pl/sql?

1040

Is microsoft sql free?

1101

what is commit? : Sql dba

1074

What is a parameter query?

1083

What is sql catalog?

1019

What is clause in sql?

1108

Can we commit in trigger?

977

How much does sqlite cost?

1038

How to display the current date in sql?

1077

What is coalesce sql?

998

What are the benefits of pl sql?

1121

Are dml statements autocommit?

1045

Is it possible for a table to have more than one foreign key?

1030

What is pls integer?

1043

What is the difference between the sql*loader and import utilities? : aql loader

1043