Oracle Client, stored procedures and Cursor release.

  • Thread starter Thread starter bclegg
  • Start date Start date
B

bclegg

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
 
Hi Bob,

I think there is no many things we can do in the client.
Usually we can save the resource by closing the connection, but we can not
guarantee if the oracle server will realease the resource related with the
connection immediately. Or if oracle has provided some system call just
like a stored procedure(e.g. something like close cursor), and we can exec
the sp in the client.
So I think you may also try to post the question to oracle community.
http://otn.oracle.com/community/index.html

Hope this helps.

Best regards,

Peter Huang
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.
 
Back
Top