Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How To Declare Host Variables in VB

Re: How To Declare Host Variables in VB

From: Jim Kennedy <kennedy-family_at_home.com>
Date: Tue, 27 Nov 2001 11:21:07 GMT
Message-ID: <DGKM7.83963$XJ4.45873705@news1.sttln1.wa.home.com>


Why do you lock the table for insert? I can't think of a good reason for doing this.
Jim
"Aman" <gulatiaman_at_yahoo.com> wrote in message news:8b8e8b44.0111262308.e8c7ffe_at_posting.google.com...
> We are declaring an Anonymous block of PL/SQL to insert new data into
> the database. In the anonymous block of PL/SQL we need to lock the
> table for insert initially, we are also generating the next valid ID
> that needs to be associated with the new record. And after the insert
> is a success we commit the changes and come out of the PL/SQL. And
> Incase the insertion fails we rollback the transaction and exit the
> block.
> As mentioned earlier ID is being generated manually inside the block.
> Now in order to carry on we need to find the ID for which the record
> was inserted.
> If somehow we could declare the host variable in VB it would make my
> life a lot simpler.
Received on Tue Nov 27 2001 - 05:21:07 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US