Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> FRM-40815: Variable Global.using-Transactional-Triggers does not exist
Hi everyone,
I have in the Data Block Trigger ON-SEQUENCE-NUMBER
Begin
IF :Global.Using_Transactional_Triggers = 'TRUE' THEN User_Exit('orderid seq=MEDORDER_ID'); ELSE Generate_Sequence_Number; END IF;
:SEQUENCE.sys.medorder_id.NEXTVAL
when I use the form, the number increment but this error appears FRM-40815: Variable Global.using-Transactional-Triggers does not exist
I obtain this instruction using the help of Forms, I don't know if make the best use of this method.
My goal when I use this method was use the sequence created to increment automatically an ID number.
Thanks,
Maga
-- Message posted via DBMonster.com http://www.dbmonster.com/Uwe/Forums.aspx/oracle/200511/1Received on Tue Nov 15 2005 - 13:56:29 CST