I have a simple job that suppose to insert one record into an oracle table.
Tried all kind of things but will not insert the record if it has a null or anything else such as 0000-00-00 00:00:00, etc. Running the sql in SQL Developer, inserts fine, but the same code in OCI stage it either will not insert it or aborts.
The timestamp is nullable in the OCI table and transformer stage.
My job looks like this: dummy file------>transformer-------->OCI
Here is my SQL:
INSERT INTO MY_TABLE(Batch_Id,StartDate,EndDate,Status) VALUES (5555,TO_DATE(sysdate, 'YYYY-MM-DD HH24:MI:SS'),NULL,'Test');
I searched the forum but nothing relevant.
Any idea why?
Oracle OCI Stage not inserting null timestamp record
Moderators: chulett, rschirm, roy