Re: Using Sequence Gen in Trigger

Rick Ryan <rickryan_at_global2000.net> wrote:

> Can a Sequence be used in a insert before row Trigger?

(snip)

>
> When I compile this trigger I get a error stating that a Sequence can't
 be
> used in this context. It seems you can only use " package_seq.nextval"
 in an
> insert statement?

'nextval' can only be specified in specific sql statements:

• the 'values' clause of 'insert' statements
• the 'set' clause f 'update' statements
• simple select statements (not in subqueries, no 'union' operator, no 'distinct', no 'group by' or 'order by' clause, no views, etc.)

Hope this helps,
Lance Humpert
Thomas Jefferson University
Philadelphia, Pa.
Lance.Humpert_at_mail.tju.edu Received on Wed Apr 30 1997 - 00:00:00 CDT