Skip to Content
0
Former Member
Sep 13, 2007 at 12:22 PM

Update procedure in JDBC Receiver

51 Views

Hi,

I am Working on Idoc to JDBC Scenario. I need to work with Insert and update procedure.

When i send the Idoc the scenario is succesful in inserting the data. But when i am resending the Idoc, the scenario is not executing in updating the record.

The error in RWB is:

Error while parsing or executing XML-SQL document: Error processing request in sax parser: Error when executing statement for table/stored proc. 'BAAN.TDCNCC002SAP' (structure 'STATEMENT'): java.sql.SQLException: ORA-00001: unique constraint (BAAN.TDCNCC002SAP_IDX2) violated

I am using action as UPDATE_INSERT.

Can some one advise me on this.

Regards,

Manoj