Problem In Updating Timestamp to a Table using Oracle -OCI9

purush · Post by **purush** » Fri Mar 23, 2007 9:34 am

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)

ray.wurlod · Post by **ray.wurlod** » Fri Mar 23, 2007 5:39 pm

Look at the SQL. What format string is being used? Do your data for the timestamp match this format string?

chulett · Post by **chulett** » Fri Mar 23, 2007 5:51 pm

I don't believe there's a macro that will get you the format you need.

Assuming your datatype is Timestamp in the job and DATE in the database, there are a ton of posts here on how to do this. A Search should turn them up.