Re: Insufficient Detail in ORA-00904 Messages

From: Brian Peasland <peasland_at_edcmail.cr.usgs.gov>
Date: Wed, 6 Oct 1999 15:03:19 GMT
Message-ID: <37FB64B7.370FC043@edcmail.cr.usgs.gov>

When I execute a command in SQL*Plus, it tells me which column is invalid. See the example below:

   SQL> select empno,e_name,job from scott.emp;    select empno,e_name,job from scott.emp

                *

   ERROR at line 1:
   ORA-00904: invalid column name

The '*' is under the invalid column. It should've been "ename". Also, if I misspelled the column name, or any other typos, I can use the SQL*Plus change command to change my command buffer. Refer to Oracle, The Complete Reference by Koch & Loney for Oracle Press.

HTH,
Brian

Jon Blake wrote:
>
> Oracle message "ORA-00904 - invalid column name" must be one of the most
> infuriating messages ever devised for not identifying the particular
> column name resulting in the error. After entering a SQL statement of
> several hundred lines which contains an incorrectly spelt column name,
> identifying the column concerned can be extreemly time-consuming. Why
> can't ORA-00904 identify the invalid column name?
>
> Anyway, does anyone know of a handy utily or whatever which can provide
> this much needed capability?
>
> Thanks in advance.
Received on Wed Oct 06 1999 - 10:03:19 CDT