Progress
DataServer
for ORACLE Guide
Allocating Cursors
ORACLE allocates a maximum number of cursors that your application can use based on system configuration, the version of ORACLE, and
init.ora
database-configuration parameters. An application can run out of available cursors. If this occurs, you can specify that ORACLE should allow more cursors or you can control how many cursors the DataServer uses with the Index Cursor (-c) connection parameter. See the "Index Cursors" section in "Connecting the DataServer," for more information.Issuing the CLOSE QUERY statement after opening a query is another technique that you can use to help minimize the number of cursors your application requires.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |