I doubt you can return BLOB as a output parameter. Try to return it as a recordset.
>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
--sb--