Hi,
I have to put Timestamp to a table and i'm using a macro for the same in the Transformer to get the Timestamp,and after that I'm loading into a Oracle Table.For the same I'm using an Oracle-OCI9 stage in the Job(Server Canvas). Whenever I try to load the Job,I'm getting an error as
ORA-01861: literal does not match format string
Any Help regarding this will be appreciated.
(Are there any restrictions like this stage will not process datatype Timestamp)
Problem In Updating Timestamp to a Table using Oracle -OCI9
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: