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 -> SQL*LOADER ORA-00904: invalid column name

SQL*LOADER ORA-00904: invalid column name

From: shan168 <shan168_at_my-dejanews.com>
Date: Thu, 18 Mar 1999 01:39:19 GMT
Message-ID: <7cplg6$he8$1@nnrp1.dejanews.com>


I have got an error while loading data from an ASCII text file into Oracle8. The control file looks like this:

INTO TABLE ADMISSION
(
ADMITTED_FROM POSITION(332:342) CHAR
"FUNC_CONVERT_ADMITTED_FROM(:ADMITTED_FROM)") I keep getting this "ORA-00904: invalid column name ADMITTED_FROM" error. I am pretty sure the column name is correct. Any people who ever encountered the same problem and can help me will be deeply appreciated.

Steph

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Mar 17 1999 - 19:39:19 CST

Original text of this message

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