General information
Title:
Oracle ADO and blobs....
What a horrible concoction; VFP + ADO + Oracle + binary objects...ooo makes me shiver at the thought.
Anyway, I'm not have any joy getting the aforementioned blob from Oracle 8 into a VFP variable.
My oracle sproc has an Output parameter of type blob. The ADO parameter object is defined thus:
loQst= loCM.createparameter("Qst",gnADOBinary,gnParamOutput,200000)
loCM.parameters.append(loQst)
I have tried adVarBinary (204) and adBinary (128), but i keep getting the error 'ORA-6550. wrong number or type of argument in call to 'mysproc'' when I execute the command object (loCM). ORA-6550 is a compilation error, but the package is compiled OK.
Any ideas folks or am I gonna be blessed with 0 blob software?
Thanks in advance...
Pablo
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only