How to find the error line number and position in a SQL statement?
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