Home » RDBMS Server » Server Utilities » What am I missing
What am I missing [message #70480] Wed, 19 June 2002 14:27 Go to next message
Nike
Messages: 2
Registered: June 2002
Junior Member
I trying to load into a table and I get this weird error. can someone please help me out.

My ctl file:
PROFIT_CENTER position(91:102) char "LOOKUP_fn(:PROFIT_CENTER)",

the error I get is:
Rejected - Error on table owner.table a, column PROFIT_CENTER.
ORA-00904: invalid column name
profit_center is the right column name on the table. I suspect its the function that is the problem because if I take the fn off then it loads fine. what am I missing here.
Re: What am I missing [message #70483 is a reply to message #70480] Wed, 19 June 2002 16:39 Go to previous message
Siva Ram
Messages: 22
Registered: November 2001
Junior Member
MAy be you don't have privileges to execute the function.

Thank You
Siva Ram
Previous Topic: Books on SQL *Loader
Next Topic: Re: Oracle problem
Goto Forum:
  


Current Time: Mon Apr 29 10:31:16 CDT 2024