Skip to Main Content

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!

How to find the error line number and position in a SQL statement?

325571Aug 19 2002
Hi,

I need one small help. When I issue a select statement like this.
SQL>select
2 *
3 from
4 wee
5 where a=10;
wee
*
ERROR at line 4:
ORA-00942: table or view does not exist

Table name "wee" is not existing in that user. What I am interested here is -
Through which data dictionary view, can I find the error message with LINE NUMBER and the position of that error(like it displayed as * in the above example) in that line.

For the procedures, functions, packages, triggers I can find in All_ERRORS or USER_ERRORS. But how to find the Error linenumber and position for a SQL statement..

Thanks in advance,
Murali

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 16 2002
Added on Aug 19 2002
3 comments
3,981 views