I've ported an ODBC app to Oracle 9i and I have the following issues:
- You can't insert a CLOB whose name is a reserved word using ODBC.
You get a driver error because the driver attempts internally to
reference the column without quoting it up even though I quote it up
in my insert statement.
- If you use blocking (SQL_ATTR_ROWSET_SIZE) then sometimes you have
to do a supplementary SQLGetData call to retrieve CLOBS where you
didn't allocate enough memory to start with. Making this call alters
the variable indicated by SQL_ATTR_ROWS_FETCHED_PTR which is not
correct as far as I can see, there is no mention of this possibility
in my copy of the ODBC programmers guide.
- Despite using SQLBindCol and SQL_ATTR_ROWSET_SIZE and various
settings for Prefetch Count in the driver retrieval of multiple rows
seems desparately slow at only around 400-500 records/second. (Dell
twin 800Mhz server). Turning off SQL_ATTR_ROWSET_SIZE reduces
retrieval to 150 records/second which seems laughable so I must be
doing something wrong.
All help gratefully received.
Received on Fri Feb 08 2002 - 03:17:30 CST
