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