Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Pass by Ref Error w/Oracle Package
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00621675
Message ID:
00625215
Views:
15
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform