Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Pass by Ref Error w/Oracle Package
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00621675
Message ID:
00625215
Vues:
9
We are also using Oracle Server and Personal Oracle release 8i or better. That is a most familiar error message. Since this is using SPT, try the Oracle ODBC drivers.

lnHandle = SQLStringConnect([Driver=Oracle ODBC Driver;UID=myid;PWS=mypwd;DBQ=sid;])

>I sure wish that syntax would work for me. With MS ODBC for Oracle v 2.573.7713.00, I get the error:
>
>Connectivity error: [Microsoft][ODBC driver for Oracle][Oracle]ORA-06550: line 1, column 7:
>PLS-00306: wrong number or types of arguments in call to 'RETURNCURSOR'
>ORA-06550: line 1, column 7:
>PL/SQL: Statement ignored

>
>whenever I try to call a procedure and don't pass something in the OUT parameter position(s), even if I use your example and leave off the parentheses.
>
>Thanks for your help. Something's still not right, but if you and Larry have it working it must be me. I guess I'll have to try some Rogaine to see whether I can get more hair to pull.
>
>>MS ODBC for Oracle v 2.573.6526.00
>>Oracle ODBC Driver v 8.01.57.00
>>
>>This is working for either set of drivers for me.
Mark McCasland
Midlothian, TX USA
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform