Oracle Client, stored procedures and Cursor release.
From: bclegg (bclegg_at_adriley.co.nz)
Date: 06/02/04
- Next message: Jörn W. Janneck: "Re: C-sharp demand on par with Assembler - Apache releases a Java app server (Re: Skills in most demand)"
- Previous message: Max: "Restarting Threads"
- Next in thread: Cor Ligthert: "Re: Oracle Client, stored procedures and Cursor release."
- Reply: Cor Ligthert: "Re: Oracle Client, stored procedures and Cursor release."
- Reply: Peter Huang: "RE: Oracle Client, stored procedures and Cursor release."
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 02 Jun 2004 16:58:39 +1200
Hi,
Does anybody know if it possible to force Oracle to release cursors that
have been generated when servicing a vb.net stored procedure call?
ie My app makes a call that populates a field in a datagrid row
This means the number of calls depends on the amount data in the grid.
The cursors are left open by Oracle and Oracle creates a new cursor for
each call, so it does take more than a few grid refreshes before you hit
ORA-1000 'Too many cursors'
Is there a way of forcing oracle to reuse the cursors.
I am asking this question here because I am expecting that this would be
provided by the Oracle Client rather than having to alter a parameter in
the database directly.
thanks
Bob
- Next message: Jörn W. Janneck: "Re: C-sharp demand on par with Assembler - Apache releases a Java app server (Re: Skills in most demand)"
- Previous message: Max: "Restarting Threads"
- Next in thread: Cor Ligthert: "Re: Oracle Client, stored procedures and Cursor release."
- Reply: Cor Ligthert: "Re: Oracle Client, stored procedures and Cursor release."
- Reply: Peter Huang: "RE: Oracle Client, stored procedures and Cursor release."
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
