Error in Oracle Update Structure
Hi All,
I had to Update a Table in Oracle with multiple records at a time, But i m not able to update it only 1 record at a time. Please look at my Structure and Correct it.
 INS_UPD_Jdbc_MT1
 SQL_Stmt
 Mon_emp
 Action
 Table
 Access
 Emp_id
 Emp_Name
 Emp_Desg
 Key
 Emp_id
This is the Update Structure. When i send a single record to update it is doing succesfully, but when sending multiple it is not getting updated.
It is giving an System error and not getting Updated.
Error Message
MP: exception caught with cause com.sap.aii.af.ra.ms.api.RecoverableException: Error processing request in sax parser: Error when executing statement for table/stored proc. 'MON_EMP' (structure 'SQL_Stmt'): java.sql.SQLException: ORA-00001: unique constraint (SAP_POC.SYS_C00118028) violated
Please Suggest me the Structure.
Points will be Rewarded.
Thanks in Advance.
Sriram