Calling Oracle Packages from VB

From: <fakringle_at_my-deja.com>
Date: 2000/05/02
Message-ID: <8enb7i$p8j$1@nnrp1.deja.com>#1/1

I got handed a package from Oracle to insert a blob data as well as other info into the DB.
I have tried to look all over and nothing matches my need.

Here is the function:

Function doInsert (

         accountId Number,
         blobdata Long Raw

) Return number;

That's the interface.

So I write my VB code:

myCommandText = "{call CreativeMgr.doInsert({accountId 164})"

    With objInsertBlob

.ActiveConnection = Conn
.CommandType = adCmdStoredProc
.CommandText = "{call CreativeMgr.doInsert({164,bytChunk()})}"
.Execute

    End With

• bytChunk() is a Byte array for an image.

All the parameters are inputs, and the return is the output.

Q1. What am I missing from the commandText? Do I need to add .param?

Q2. How do I get the return value back???

Thanks.

-Kringle

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue May 02 2000 - 00:00:00 CDT