Re: Sequence

SF wrote:

> Hi,
>
> I have created a sequence on a table.
> How can I use it in the oracle forms 6i?
>
> Thank you,
>
> LM

You can't create a sequence on a table; sequences are table independent.

In a trigger on the form:

SELECT sequence_name.NEXTVAL
INTO some_variable
FROM dual;

Daniel Morgan Received on Fri Feb 14 2003 - 17:54:59 CST