SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

PL/SQL Exception for ORA-00942 - Table or view not found?

531621Mar 23 2007 — edited Mar 23 2007

Hey there!

I want to create an exception my code runs into whenever it tries to select from a table that is not existent (or because of insufficient privileges).

How can I get these ORA-00942 errors and place them into a exception? Except for WHEN OTHERS, that's not concrete enough.

Regards,
Thomas

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 20 2007

Added on Mar 23 2007

2 comments

3,096 views