Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Help with Sequences in Embedded SQL
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 - 17:53:46 CST