Re: how to get more than ID value using nextval ???
From: Jim Kennedy <kennedy-down_with_spammers_at_attbi.com>
Date: Thu, 02 Jan 2003 16:20:15 GMT
Message-ID: <3FZQ9.601182$NH2.40535_at_sccrnsc01>
Date: Thu, 02 Jan 2003 16:20:15 GMT
Message-ID: <3FZQ9.601182$NH2.40535_at_sccrnsc01>
Let the trigger do it and set the cache on the sequence be = to at least
1,000. Also as always use bind variables and the array interface.
Jim
"Mohamed Badr" <mbm_1975_at_hotmail.com> wrote in message
news:CGSQ9.157904$F2h1.59524_at_news01.bloor.is.net.cable.rogers.com...
> Hi all
> I'm using proc/c++ to connect to oracle. the operation I wanna do is
> inserting 1000 record into a table. in case of single record, I used
> table_seq.nextval to get next ID. but I think there must be better way not
> to call it 1000 time. anybody has any idea ???
> thanks
> M.Badr
>
>
Received on Thu Jan 02 2003 - 17:20:15 CET