Date format for an Oracle database

[#1]

Hi,

While sending data from XI to an oracle database I am getting this error: "literal string does not match the format".

what is the correct date format that an Oracle Database expects?

Please help,

Thanks n Regards

Pushpinder Kaur

[Former Member]

Hi Pushpinder,

while entering to an Oracle database, you should send a query not the direct field.

OracleDateField = TO_DATE( '2008-12-31','YYYY-MM-DD')

hasQuot = No

Also define an attribute hasQuot to remove the quotes which will be inserted by XI.

Construct the above query using UDF or graphical mapping concatenate.

Let me know if you need further clarification.

-Shamly

Edited by: Shamly MM on May 23, 2008 7:27 AM