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

From: Carl Hoang <>
Date: 1997/05/11
Message-ID: <>#1/1

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, (Geoffrey Grandstaff) wrote:

>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 Grandstaff | print STDOUT q
>Oracle DBA/UNIX SA | Just another Perl hacker,
> | unless $spring
> | - Larry Wall
>------------------------------------------ */

     Carl Hoang    
     SofTech Systems, Inc.   (612) 424-7886
Received on Sun May 11 1997 - 00:00:00 CEST

Original text of this message