ORA-00904 Invalid identifier
Posted: Tue Mar 06, 2007 1:25 pm
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 ??
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 ??