David Robertson
Reputable Poster
I've browsed through all of the previous posts on TER's, and thanks to everyone for the info that provided.
I have a slightly vexing question though, as far as actually coding the TER goes.
In the TER, specifically on the "before insert", "before update", and "before delete" events, under certain conditions, I need to block the insert/update/delete.
I have tried using the SET TER ERROR system function, but this seems to have no effect what-so-ever. Anyone know how this is supposed to work?
I tried changing the key values to NULL, it actually works perfectly, and the user does not see any error message (although this may not be the case from all APPL's), but the JDE.LOG shows:
OCI0000178 - Unable to execute - 0 - INSERT INTO TESTCTL.F0005 (DRSY, DRRT, DRKY, DRDL01, DRDL02, DRSPHD, DRUDCO, DRHRDC, DRUSER, DRPID, DRUPMJ, DRJOBN, DRUPMT) VALUES BND1,:BND2,:BND3,:BND4,:BND5,:BND6,:BND7,:BND8,:BND9,:BND10,:BND11,:BND12,:BND13)
138/41 Mon Nov 05 16:18:09 2001 DBPERFRQ.C384
OCI0000179 - Error - ORA-00001: unique constraint (TESTCTL.F0005_1) violated
138/41 Mon Nov 05 16:18:09 2001 jdb_drvm.c887
JDB9900401 - Failed to execute db request
138/41 Mon Nov 05 16:18:09 2001 jdb_exet.c4432
JDB3400009 - Failed to perform Insert for F0005
I would like to leave the logs a bit cleaner than this.
Any ideas greatly appreciated.
Dave
OW B733.2 sp16... Oracle on RS/6000
I have a slightly vexing question though, as far as actually coding the TER goes.
In the TER, specifically on the "before insert", "before update", and "before delete" events, under certain conditions, I need to block the insert/update/delete.
I have tried using the SET TER ERROR system function, but this seems to have no effect what-so-ever. Anyone know how this is supposed to work?
I tried changing the key values to NULL, it actually works perfectly, and the user does not see any error message (although this may not be the case from all APPL's), but the JDE.LOG shows:
OCI0000178 - Unable to execute - 0 - INSERT INTO TESTCTL.F0005 (DRSY, DRRT, DRKY, DRDL01, DRDL02, DRSPHD, DRUDCO, DRHRDC, DRUSER, DRPID, DRUPMJ, DRJOBN, DRUPMT) VALUES BND1,:BND2,:BND3,:BND4,:BND5,:BND6,:BND7,:BND8,:BND9,:BND10,:BND11,:BND12,:BND13)
138/41 Mon Nov 05 16:18:09 2001 DBPERFRQ.C384
OCI0000179 - Error - ORA-00001: unique constraint (TESTCTL.F0005_1) violated
138/41 Mon Nov 05 16:18:09 2001 jdb_drvm.c887
JDB9900401 - Failed to execute db request
138/41 Mon Nov 05 16:18:09 2001 jdb_exet.c4432
JDB3400009 - Failed to perform Insert for F0005
I would like to leave the logs a bit cleaner than this.
Any ideas greatly appreciated.
Dave
OW B733.2 sp16... Oracle on RS/6000