DSXchange

Hi All,

I create a simple job with DS => TRT => OCI
I read a single column in the dataset (ID Bigint) then i add a column timestamp (UPDT_DATE CurrentTimestamp()) in the transformer.
I insert them into a table IVRS_DATA_LOG in load and append with parallel option and NLS WE8ISO8859P1.
There's just one line.

Then i have this message error :
SQL*Loader-925: Error while uldlpim: OCIStmtExecute
ORA-00904: "MESSAGE_NUM": Invalid identifier

I don't know where this column come from ?!!??
My oracle table have four columns and i insert data into two of them.
This column doesn't exist. So anybody have an idea ??

What about your metadata? Do you have this column there? Do you have user defined sql?

Add a environment variable APT_STRING_PADCHAR to your job and set the value to 0X00

Hope it helps....

[quote="DSguru2B"]What about your metadata? Do you have this column there? Do you have user defined sql?[/quote]

this column don't exist in the target and i don't use user defined in this case.

[quote="csrazdan"]Add a environment variable APT_STRING_PADCHAR to your job and set the value to 0X00

Hope it helps....[/quote]

i'l see it tomorow at work thanks.

Make sure you have the correct qualified name for the database table.

FOUND.

OCI PX stage need to read/write an Oracle view using LOAD (SqlLoader) and it seems that in Oracle 9i or in the Database i want to insert data 9.2.0.1 version, there's just a column MESSAGE and not MESSAGE_NUM.
I changed to upsert and it works,

Thanks.