Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Simulating Next and Previous in Oracle
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
00187155
Message ID:
00187348
Vues:
24
>>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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform