Referencing a SEQUENCE from a trigger...

Hello,
I've got a situation where I need to insert rows into a table in a ON-VALIDATE-FIELD trigger. For these rows, I need a serial no which I'm getting from a SEQUENCE. However, I can't seem to reference the SEQUENCE. I'm doing something like:

  new_ref := :SEQUENCE.V_REF_NO_SEQ.NEXTVAL;

which gets me the error messages:

  PL/SQL error 49 at line 10, column 16:

     bad bind variable 'sequence.v_ref_no_seq'

I've gone through the _SQL Language Reference_ and _SQL*Forms Designer Reference_ and I can't find anything useful there. Is the ":SEQUENCE." syntax only valid for use with default value?

George
george_at_unixg.ubc.ca Received on Mon Jul 20 1992 - 21:55:14 CEST