Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Oracle remote views have incorrect field sizes?
Message
From
27/03/2000 20:06:40
Paul De Niverville
Deniverville Econometric Research Ltd.
Victoria, British Columbia, Canada
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00349742
Message ID:
00351168
Views:
25
Hi,

What are LOBs?

I have seen MS ODBC driver for Oracle recommened here at the UT over Oracle's ODBC drivers. Would the MS one have had this problem?

Paul


>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform