What am I missing [message #70480] |
Wed, 19 June 2002 14:27 |
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.
|
|
|
|