Designing Applications for Performance and Scalability
This white paper discussed how Oracle users cursors as the main
mechanism between SQL statements in an application program and the
database. The paper discusses how cursors should be used, the
concept of bind variables and
how proper application design is done.
Guidelines are included for many popular application programming
interface, including OCI, ODBC, and PL/SQL.
The whitepaper is available from the Oracle Technology Network in the database
white papers section.
This
link will take you directly to the paper itself.
A free registration is required to access contents on the Oracle
Technology Network.