Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Oracle remote views have incorrect field sizes?
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00349742
Message ID:
00350749
Views:
34
After much hair-pulling and name-calling I've managed to track down the problem with the help of our Oracle DBA. It turns out this was not a VFP problem at all, but an ODBC problem. It appears VFP has real problems with Oracle LOB's. Turning off LOB's in the ODBC config fixes the following problems in VFP:

1. Invalid argument in OCI Call errors
2. Oracle long field types displaying trash characters in views

Michael G. Emmons
memmons@nc.rr.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform