Re: Pro*C question. Return value t to struct

You can get that value ahead of time and then update the table with it. Either way you have to have 2 SQL statements.

On Mon, 5 May 1997 21:19:47 GMT, grandst_at_netcom.com (Geoffrey Grandstaff) wrote:

>Hi.
>
>I was asked by a programmer today how to do the following:
>
>During an insert into a table through a C++ program, the programmer
>inserts a row. One of the columns uses a sequence_name.NEXTVAL for
>its insert. Is there anyway to return that value to the program and
>update the structure without making another database call to the database?
>Thanks for your help. I have not had to use Pro*C very much and I am
>looking in the manual.
>
>Geoff
>
>
>--
>/* ------------------------------------------
>Geoff Grandstaff | print STDOUT q
>Oracle DBA/UNIX SA | Just another Perl hacker,
>ggrandst_at_aol.com | unless $spring
>grandst_at_netcom.com | - Larry Wall
>------------------------------------------ */

     Carl Hoang              choang_at_visi.com
     SofTech Systems, Inc.   (612) 424-7886