Re: SQL*LOADER ORA-00904: invalid column name

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 18 Mar 1999 06:39:48 +0100
Message-ID: <36F091A4.7955023A@sybrandb.demon.nl>

The only thing that could be wrong is no execute privilege on the function func_convert_admitted_from, but then the error message is wrong also. You will receive 904 errors though if you use a function in any select list if you don't have privilege.
Could you check out whether you have privilege and/or a proper synonym?

Hth,

Sybrand Bakker, Oracle DBA

shan168 wrote:

> 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 - 23:39:48 CST