AppEngine not abending on Unique Constraint
Hello,
We use PeopleSoft FSCM and are on PUM 51, PeopleTools 8.60.16 on Oracle 19.
We are running an AppEngine with PeopleCode inserting data into a table using SQL object's Execute method. The program isn't abending when the code encounters a Unique Constraint on the Insert statement.
Code
&CISP_Rec = CreateRecord(Record.U_CISPLUS_TBL);
&SQL = CreateSQL("%Insert(:1)");
…
assign values to the KEY fields and other fields
…
&SQL.Execute(&CISP_Rec);
The data being passed into the unique KEY fields and all the other fields in the table are exactly same but on first attempt the row is inserted and the program continues with further processing. On second attempt the row isn't inserted and trace shows RC=805 but the program continues.