SQLPlus Bug (ORA-00904: invalid column name)?

From: Ora <oracle_fan_at_sbcglobal.net>
Date: 26 Nov 2003 08:11:04 -0800
Message-ID: <1cf2c0d8.0311260811.7f15936b@posting.google.com>

I am using SQLPlus version Release 8.1.6.0.0.

When I run a script (example: sqlplus @some_script.sql) I get the following error message:

SELECT X.COL1, Y.C2

                 *

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

When I open the script and look at line 49 I see Y.COL2 and not what SQLPlus says it parsed (that is Y.C2).

I closed the script and ran it again and did not get the ora-00904 message!!

The only difference between the first and second time I ran the script was: during the first script run, a long running (5+ hour) procedure errored out after 5 hours and then the select statement was run which failed with a ora-00904. During the second run I commented out the procedure so that I didn't need to wait for 5 hours for the select to run.

Thanks. Received on Wed Nov 26 2003 - 10:11:04 CST