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