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 ??
ORA-00904 Invalid identifier
Moderators: chulett, rschirm, roy
Re: ORA-00904 Invalid identifier
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.
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.