User_Errors table OR show error on sql promt.

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

Question Posted / swapna

Answer Posted / swapna

User_Errors table
OR
show error on sql promt.

Is This Answer Correct ?

7 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What does the acronym acid stand for in database management?

1022

what is a trigger? : Sql dba

1012

Why is a trigger used?

926

How do you update a sql procedure?

1012

What is crud sql?

963

What is pl sql block structure?

1016

How do you write an index?

949

Are sql database names case sensitive?

981

Explain the difference between 'between' & 'and' operators in sql

981

How do you use join?

921

Explain what is sql?

1098

What is set serveroutput on?

1120

Is it possible to create startup or shutdown trigger for on-schema?

1012

What does pl sql stand for?

1097

What is the meaning of disabling a trigger?

1152