Tom

I have been looking through the supplied documentation, but I don't see anything on inserting a primary key column value based on a sequence from Pro*C.

I.e. I want to do something like:

insert into data
(a, b, c)
values (seq.nextval, :bval, :cval)

Also, how do I do this (insert the primary key from a sequence) if I insert using a record structure, and lastly, how do I do this if I insert using an array of records?

The reason for basing the primary key on a sequence, is that other processes could also insert into the table, and I need a central generator of sequence numbers.