cancel
Showing results for 
Search instead for 
Did you mean: 

Oracle JDBC Receiver

Former Member
0 Kudos

Hi XI Guru,

I have problem in JDBC Receiver. My error is

" Message processing failed. Cause: com.sap.aii.af.ra.ms.api.RecoverableException: Error processing request in sax parser: Error when executing statement for table/stored proc. 'ps_gl_active_acct_' (structure 'Statement'): java.sql.SQLException: ORA-01843: not a valid month "

Currently I am using TransformDate function in graphical mapping.

Source Format : yyyy-mm-dd Type xsd:date

Target format : dd/mm/yyyy. Type xsd:date

I have tried mm/dd/yyyy

Please give me some advise and tips to solve my problem.

Regards,

Accepted Solutions (0)

Answers (3)

Answers (3)

Jitendra_Jeswan
Contributor
0 Kudos

use this function

TO_DATE('<originalDate>','YYYY/MM/DD') : You have to form this string using the concate function in the graphical mapping.

Use the above function in graphical mapping to map the exact date in ORACLE.

You will have to use 'hasquot' attribute and set it to "NO" of the Date field. It will be solved then..

follow this link: /people/alessandro.berta/blog/2005/10/04/datetime-datatypes-and-oracle-database

Regards.

Jeet

Edited by: Jeet Jeswani on Feb 25, 2008 12:44 PM

Former Member
0 Kudos

Hi,

In source give yyyy-MM-dd (change the mm to capital MM)

Target format : dd/MM/yyyy

And test the mapping in message mapping using the XML pay load which u have got while executing the scenario,if it done work update the thread.

Regards,

Phani

Former Member
0 Kudos

HI,

CHECK WHETHER U HAVE GIVEN THE CONNECTION AND JDBC DRIVER FOR ORACLE DATABASE PROPERLY.EVEN I HAVE GOT MANY A TIMES THESE PROBLEM WHILE USING ORACLE DATABASE.

CAN U PLZ TELL ME CONNECTION AND DRIVER UR USING

PLZ REWARDS POINTS

VIKAS