If the value of MaxLargeData is greater thanthe data fetched is only bytes. See Table in Section The default value of MaxLargeData is 0. Starting from Oracle Database 12 c Release 1 Implements ODBC support for implicit results. This support eases any third party ODBC application, which migrated to Oracle and wants to use this same functionality that was provided by their previous vendors. Oracle ODBC driver now supports executing a stored procedure, which can return implicit results without using RefCursor.
Figure shows the components of the ODBC model.įigure shows an ODBC application accessing three separate databases. Therefore, the application can access any data source for which a database driver exists.Ī library of ODBC function calls that allows an application to connect to a data source, execute structured query language SQL statements, and retrieve results.
A database driver links the application to a specific data source.Ī database driver is a dynamic-link library that an application can invoke on demand to gain access to a particular data source.
The application's source code does not have to be recompiled for each data source. Open Database Connectivity ODBC provides a standard interface that allows one application to access many different data sources.
