Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Simulating Next and Previous in Oracle
Message
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00187155
Message ID:
00187348
Views:
26
>>The error I receive is as follows:
1526
Connectivity error: [Oracle][ODBC Oracle Driver][Oracle OCI]ORA-01009: missing mandatory parameter.<<

The 1st thing to look at how many fields are in the VFP cursor -- actually how many memo fields that are mapped to VARCHAR2 Oracle datatypes. There seems to be some kind of issue with the number of varchar2 'characters' that can be dealt with. I have an app that has one table with about 10 memo fields which were mapped to varchar2(2000) in Oracle and I got the same error message. I avoided the error by reducing the number of memo fields in the cursor and/or going from varchar2(2000) to varchar2(1000) on some of the Oracle fields. Both approaches seem to eliminate the error. It is a trial and error thing.

Kevin
Kevin Emmrich
www.jkt9000.com
Previous
Reply
Map
View

Click here to load this message in the networking platform