Information générale
Titre:
VFP6.0 Upsizing Wizard - Export Data Errors to Oracle8
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
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement