ORA-00001: Unique Constraint Violation in EMR.PATIENT_PRESC Table

The error message indicates that there was an error updating the database due to a unique constraint violation. The constraint ///'IDX_PRESC_1///' in the ///'EMR///' schema was violated./n/nThe error likely occurred in the ///'PatientPrescMapper.java///' file in the ///'com.haoze.outpatdoctor.dao///' package, specifically in the ///'insertSelective///' method./n/nThe error occurred while setting the parameters for an SQL insert statement. The insert statement attempted to insert values into the ///'EMR.PATIENT_PRESC///' table, but one or more of the values violated the unique constraint./n/nThe specific SQL insert statement that caused the error is shown in the error message./n/nINSERT INTO EMR.PATIENT_PRESC ( DATA_VERSION,GMT_CREATE,GMT_MODIFY,HOSPITAL_ID,PRESC_ID,OUTPAT_NUM,PAT_TYPE_ID,DEPT_ID,PRESC_NUM,CREATE_DATETIME,CREATE_DEPT_ID,CREATE_PERSON_ID,PRESC_TYPE,PRESC_DIAG,DRUG_DEPT,STATUS,FROM_TYPE,MM_FLAG ) VALUES( ?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,? )/n/nThe cause of the error is a java.sql.SQLException, which is thrown when the unique constraint ///'IDX_PRESC_1///' is violated./n/nThe complete error message is: ///'Error updating database. Cause: java.sql.SQLException: ORA-00001: unique constraint (EMR.IDX_PRESC_1) violated; ORA-00001: unique constraint (EMR.IDX_PRESC_1) violated; nested exception is java.sql.SQLException: ORA-00001: unique constraint (EMR.IDX_PRESC_1) violated.///