Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Cursoradapters and oracle10g using ODBC
Message
From
16/02/2006 16:03:57
 
 
To
16/02/2006 04:16:38
General information
Forum:
Visual FoxPro
Category:
Client/server
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows 2000
Database:
Oracle
Miscellaneous
Thread ID:
01096681
Message ID:
01096881
Views:
14
>(The cursoradapter does not seem to be able to send a Stored Procedure call; setting the cursoradapter's InsertCmd to 'CALL tablename_inscmd(...)' fails with an Oracle SQL parsing error from the driver).
>

Hi Andrew,

So, ODBC driver doesn't like the syntax you are using and you are jumping to conclusion that "cursoradapter does not seem to be able to send a Stored Procedure call"? Interesting. You could try ODBC escape syntax for SP calls:
{[?=]call procedure-name[([parameter][,[parameter]]...)]}

Aleksey.
Previous
Reply
Map
View

Click here to load this message in the networking platform