Information générale
Titre:
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
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement