Re: SQL Error
From: Jochen Van den Bossche <Jochen.VandenBossche_at_proximus.net>
Date: 23 Aug 2002 06:38:16 -0700
Message-ID: <4160e74e.0208230538.4c4ae94c_at_posting.google.com>
END; Change the limits for the loop (currently 1..30999 i think) to get them all.
In that case it will be to much for dbms_ouput, so use a table (as in the comments)
This comes (almost) right out of the oracle documentation (PL-SQL User's Guide and Reference / 6 Error Handling). read it. Received on Fri Aug 23 2002 - 15:38:16 CEST
Date: 23 Aug 2002 06:38:16 -0700
Message-ID: <4160e74e.0208230538.4c4ae94c_at_posting.google.com>
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
DECLARE
err_num NUMBER;
--err_msg VARCHAR2(2000);
BEGIN
/* Get all Oracle error messages. */
FOR err_num IN 17..77 LOOP
-- err_msg := SQLERRM(-err_num);
-- INSERT INTO errors VALUES (err_msg);
dbms_output.put_line(SQLERRM(-err_num));
END LOOP;
END; Change the limits for the loop (currently 1..30999 i think) to get them all.
In that case it will be to much for dbms_ouput, so use a table (as in the comments)
This comes (almost) right out of the oracle documentation (PL-SQL User's Guide and Reference / 6 Error Handling). read it. Received on Fri Aug 23 2002 - 15:38:16 CEST