Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Insufficient Detail in ORA-00904 Messages

Insufficient Detail in ORA-00904 Messages

From: Jon Blake <jblake_at_swin.edu.au>
Date: Wed, 06 Oct 1999 10:14:45 +1000
Message-ID: <37FA9475.7D4F0C8B@swin.edu.au>


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 Tue Oct 05 1999 - 19:14:45 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US