SQL Loader Error while uld: OCIStmtExecu while loading

aakashmalu · Post by **aakashmalu** » Wed Oct 28, 2009 4:31 pm

Hi,

I am trying to migrate a datastage job from Datastage 7.5 to 8 which loads a dataset in to an oracle table using SQL Loader. I am using ORA OCi

Write Method = Load
Write Mode = Append

This job runs absolutely fine in 7.5 but in version 8 i am getting the following error

SQL*Loader-925: Error while uldlpim: OCIStmtExecute
ORA-00904: "MESSAGE_NUM": invalid identifier

Anybody has any idea on this..

Thanks in advance
Aakash

chulett · Post by **chulett** » Wed Oct 28, 2009 4:40 pm

This is a new 8.x install, separate from your 7.5 server? Is this the first time you've tried a 'sql loader' job or do others work but not this one?

ray.wurlod · Post by **ray.wurlod** » Wed Oct 28, 2009 4:41 pm

Ordinarily that would mean that MESSAGE_NUM is not a valid column name in the table that you're loading. Do check that you specified the correct table name.

chulett · Post by **chulett** » Wed Oct 28, 2009 4:45 pm

Looks like this can come from a client / database version mismatch:

http://www.orafaq.com/maillist/oracle-l ... 7/0386.htm

aakashmalu · Post by **aakashmalu** » Thu Oct 29, 2009 12:42 pm

chulett wrote:Looks like this can come from a client / database version mismatch:

http://www.orafaq.com/maillist/oracle-l ... 7/0386.htm ...

Criag,

Thanks for the link.... I changed the Direct Load from TRUE to FALSE and the job ran successfully....

$APT_ORACLE_LOAD_OPTIONS = OPTIONS (DIRECT=FALSE, PARALLEL=TRUE)

Thanks
Aakash

chulett · Post by **chulett** » Thu Oct 29, 2009 1:24 pm

I guess slower and successful > faster and fatal.