Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Detail Error Handling

Status
Not open for further replies.
asth01

asth01

Programmer
Jan 18, 2004
36
US
Hi,

I want to handle exception in a way that I can get some more data out of the exception thrown by Oracle.

For example, I get an error code -942 which is for table or view not found. I also want to know "what" table of view is not found.

Can I get to know from Oracle what table or view is not found? I want this table name in a PL/SQL procedure.

Thanks,
Rajeev.
 
Status
Not open for further replies.

Similar threads

TheLazyPig
  • Locked
  • Question
Inserting Text Decimal to Table Error
Replies
4
Views
396
carp
carp
Aung Thurein Tun
  • Locked
  • Question
opera_mail.AuthenticateCredential error ORA-20001 in Oracle Database
Replies
0
Views
153
Aung Thurein Tun
Aung Thurein Tun
EM1107
  • Locked
  • Question
Getting the error ORA-06550: line 2, column 21: PLS-00103: Encountered the symbol "end-of-file" when
Replies
2
Views
232
EM1107
EM1107
Cretin
  • Locked
  • Question
error ORA-29260
Replies
1
Views
169
SamBones
SamBones
Ken
  • Locked
  • Question
How to make SQL sub query work in Oracle, getting error ?
Replies
4
Views
167
Beilstwh
Beilstwh

Part and Inventory Search

Sponsor

Back
Top