Re: How To Declare Host Variables in VB

From: Dave Haas <davehaas_at_dont.spam.me.hotmail.com>
Date: Tue, 27 Nov 2001 23:42:21 GMT
Message-ID: <xxVM7.27177$un4.4467810@news1.telusplanet.net>

Hi Aman.

Have a look at the Oracle Objects for Ole stuff. It allows you to bind input and output variables from VB into PL/SQL code, and it works with anonymous blocks as well.

HTH Dave Haas

"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 - 17:42:21 CST