Re: Help with Sequences in Embedded SQL

Hello Teresa:

    I'm not sure what you mean by embedded SQL but one way to insert the key by selecting it from the sequence is to use a trigger stored in the database.

    Van

Teresa Mah wrote in message <363CF48A.CAD60F1D_at_home.com>...
>Hi,
>
>I've already created a table and a sequence for the primary key of the
>table in SQL*Plus. Now, I want to write an Embedded SQL function which
>inserts tuples into the table, uses the sequence for the primary key
>values. However, when I compile my Embedded SQL code and try to run it,
>nothing gets inserted into the table because the compiler does not
>recognize the sequence name. Does anyone know how to fix this?
>
>Any help would be very much appreciated.
>
>Thank you.
>
>Teresa
Received on Sun Nov 01 1998 - 19:47:59 CST