Integration

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

DB Adaptor and inserting dates into Oracle DB

Pnewham-OracleAug 10 2005 — edited Aug 10 2005

Hi,

I'm using the Oracle DB Adaptor to poll a table in one instance (using logical delete) and to invoke a DB adaptor to insert/merge a row into a separate instance.

NOTE :both tables have different definitions.

I am using a BPEL transform to tfrm the data received from the poll/receive step.

I need to transform some date variables and the target date column CreatedTs is expecting to receive the date in the Oracle DD-MON-YYYY format (can't change the NLS_DATE_FORMAT value for the target).

I'm trying to use the provided xsl:formatDateTime function with various formats but can't get anything useful to work.

Any ideas ?

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 7 2005

Added on Aug 10 2005

#bpel, #soa-process-management

1 comment

847 views