Hi,
Having just tested our database on V8.2 we get the following apparent
incompatibility.
A Trigger conatains the following line
CREATE TRIGGER JABS.AU_CHNG_ENQUIRYITM
AFTER UPDATE OF
..
..
SET v_change_notes_oid = NEXTVAL FOR JABS.CHANGE_NOTES_OID;
..
The trigger still CREATEs OK, but always now gives the following
runtime error
after an update?
SQL0723N An error occurred in a triggered SQL statement in trigger
"JABS.AU_CHNG_ENQUIRYITM". Information returned for the error
includes
SQLCODE "-348", SQLSTATE "428F9" and message tokens "NEXTVAL FOR
JABS.CHANGE_NOTES_OID". SQLSTATE=09000
Do we need to change how this is coded or is this a new V8.2 Bug
(we were on V8.1.6 before) ?
Thanks.
Paul.