Re: SQL Error

ALL_ERRORS just show you the current errors on the objects you have access to.
If you are looking for a table that contains all ORACLE error messages, you may be out of luck. I know there is such a system table in SQL server. Not in ORACLE. You can however use SQLCODE, SQLERRM in your ORACLE code to check what is the error code and message of your last executed SQL.

Venkateshwaran.I_at_geind.ge.com (Venkat) wrote in message news:<b9f3c8e9.0208122314.179759ec_at_posting.google.com>...
> Hi Friends,
>
> I have issued a SQL statement like this,
>
> SQL>select *
> 2 from
> 3 ;
>
> *
> ERROR at line 3:
> ORA-00903: invalid table name
>
>
> I am interested in knowing from where this error message comes, Is it
> coming from any view or table. It is showing error like line no 3 like this,
> I could not find this in ALL_ERRORS.
>
> Could you anybody please some idea.
>
> Thanks in Advance,
> Venkat
Received on Tue Aug 13 2002 - 18:19:57 CEST