Re: OCI vs. ODBC questions

On Thu, 03 Dec 1998 12:27:32 -0500, BC <bmcz_at_yahoo.com> wrote:

>SQL_CONCURRENCY (SQL_CONCUR_READ_ONLY)
>SQL_CURSOR_TYPE (SQL_SCROLL_FORWARD_ONLY or SQL_CURSOR_KEYSET_DRIVEN)

The RDBMS only supports forward scrolling cursors, and given the way that Oracle handles transactions and read-consistency, the SQL concurrency point is likely moot. You can look at the OCIStmtExecute() parameters, perhaps the snap_in/snap_out can be used the way that you want.

>SQL_ROWSET_SIZE

This would be controlled via use of Array Fetches...

>SQL_BIND_TYPE

This is implicit since with OCI you are controlling exactly how the binding is done.

OCI doesn't do much of the work for you, the interface is much more complex that that of ODBC - you have to do the low level control that the driver would be handling for you via ODBC. Not that this is a bad thing, by using OCI you get a lot better performance and you can tune the calls for exactly what you are doing. Received on Wed Dec 09 1998 - 11:03:55 CST