Re: Insufficient Detail in ORA-00904 Messages

Many thanks for your response. However, I often execute queries from a tool other that SQL*Plus, such as Microsoft Access in passthrough mode. When a column name is incorrectly spelled, the tool only returns the Oracle error message - hence the desire to have the offending name identified in the message itself. There are many Oracle errors - eg., 01577 - for which the message text includes a particular object identification. It would be handy if 00904 also did this.

Regards
  Jon Blake

Brian Peasland wrote:

> 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 - 18:24:48 CDT