Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Oracle ADO and blobs....
Message
 
 
À
18/01/2002 08:05:45
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
00606625
Message ID:
00608598
Vues:
16
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--
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform