General information
Title:
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)
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only