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 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.


Helpful Answer

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