Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VFP6.0 Upsizing Wizard - Export Data Errors to Oracle8
Message
From
27/04/2000 16:16:34
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Client/server
Title:
VFP6.0 Upsizing Wizard - Export Data Errors to Oracle8
Miscellaneous
Thread ID:
00364267
Message ID:
00364267
Views:
58
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
Map
View

Click here to load this message in the networking platform