Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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

Former Member

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question