Hi,<br><br>ERROR: ORA-01000 MAXIMUM OPEN CURSOR<br>RDBMS: ORACLE 8.0.5<br> S.O.: LINUX<br>DELPHI: 5.0<br>BDE: 5.01<br><br>I use a Query to execute an oracle function that create, open, execute and close an oracle cursor. <br><br>The query is Create, Open, Close and Free n times, but the<br>oracle cursor still in memory.<br><br>What a can close the cursor?<br><br> <br>
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
MAXIMUM OPEN CURSOR
- Thread starter Mauro
- Start date
Guest_imported
New member
- Jan 1, 1970
- 0
1. Oracle sets the maximum number of cursors. The default is pretty low and can be changed. I don't know how you do that. Our DBA takes cares of that stuff.
2. Per past experience with Oracle, the cursor won't go away until the data module where the query would be sitting is destroyed. In the same manner, if you watch carefully, on the datamodule.created a cursor gets created for every query it has. Contrary to the sensible assumption that it would be created on the query.open
2. Per past experience with Oracle, the cursor won't go away until the data module where the query would be sitting is destroyed. In the same manner, if you watch carefully, on the datamodule.created a cursor gets created for every query it has. Contrary to the sensible assumption that it would be created on the query.open
- Status
Similar threads
