IDS : Passing BLOBs to SPL functions using VB6, OLEDB and ADO
Hi,
I'm trying to write BLOBs to a table via an SPL function.
The function header looks like:
create function BLOBTest_insert(
aBLOB BLOB
)returning int;
In the VB code I create a parameter of type adBinary (this maps to the
OLEDB type DBTYPE_BYTES). I open a file using the ADO stream object
and use the object's Read method to read the contents of the file into
a byte array which I then set as the value of the parameter.
Trouble is, when I execute the ADO command I get an error message:
"EU0001: (-937) blob_input: cannot convert LO from argument string"
What am I doing wrong ?
Thanks :-)
P.S. I'm using IDS 9.4 and Client SDK 2.9