Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Oracle ADO and blobs....
Message
From
18/01/2002 08:05:45
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Client/server
Title:
Oracle ADO and blobs....
Miscellaneous
Thread ID:
00606625
Message ID:
00606625
Views:
42
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
Map
View

Click here to load this message in the networking platform