Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
VFP6.0 Upsizing Wizard - Export Data Errors to Oracle8
Message
De
27/04/2000 16:16:34
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Titre:
VFP6.0 Upsizing Wizard - Export Data Errors to Oracle8
Divers
Thread ID:
00364267
Message ID:
00364267
Vues:
55
Vfp6.0 was successful upsizing and creating the Oracle tables. Then it tried to create a procedure that would insert the data into the new table. Oracle posted a PL/SQL compilation error. I have been unable to find any discusion of the upsizing wizard generating this type of error. Is there something I've missed here? Or do I have to create and run the code after table creation. In that case, Oracle SQL Loader is easier. A snippet of my ODBC Data Source Administrator log follows. Thanks for any suggestions.

Bob

VFP6 119:110 ENTER SQLExecDirect
HSTMT 0x02eb1b18
UCHAR * 0x02cf1010 [ -3] "CREATE PROCEDURE rwf_insert_ (xBig CHAR, x1 char, x179 char, x180 char) AS BEGIN\ a\ dINSERT INTO mdrc\ aVALUES (x1);\ a\ dINSERT ..."
VFP6 SDWORD -3

VFP6 119:110 EXIT SQLExecDirect with return code -1 (SQL_ERROR)
HSTMT 0x02eb1b18
UCHAR * 0x02cf1010 [ -3] "CREATE PROCEDURE rwf_insert_ (xBig CHAR, x1 char, x179 char, x180 char) AS BEGIN\ a\ dINSERT INTO mdrc\ aVALUES (x1);\ a\ dINSERT ..."
VFP6 SDWORD -3

DIAG [S1000] [Oracle][ODBC][Ora]Trigger, procedure or function created with PL/SQL compilation error(s). (24344)
Répondre
Fil
Voir

Click here to load this message in the networking platform