RE: Oracle Client, stored procedures and Cursor release.

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Peter Huang (v-phuang_at_online.microsoft.com)
Date: 06/02/04 

Date: Wed, 02 Jun 2004 09:51:47 GMT

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.

Relevant Pages

  • system() return code always -1 after DBI/DBD local connection
    ... I am attempting to package a common Perl v5.8.6 + DBI ... Oracle 10g client and appears to be able to connect OK ... After making a connection with DBI, ...
    (perl.dbi.users)
  • Re: Oracle 8i installation on RedHat Linux 7.3
    ... >I can connect from client to my server at linux system now. ... >different name and check your connection again. ... Copyright 1997 Oracle Corporation. ...
    (RedHat)
  • Re: HELP
    ... Not familiar with specs for Oracle Client, ... ODBC driver). ... >> Connection and Recordset Objects) in order to use ODBC ...
    (microsoft.public.excel.programming)
  • Re: Need advices for mysqldb connection best practice
    ... creating a connection at each client connection (but ... I'm afraid it overloads the mysql server) ... to implement resource locking. ...
    (comp.lang.python)
  • Re: port forwarding
    ... It sounds like you're running into Oracle's port redirection... ... Client reconnects to the indicated IP and port. ... Run Oracle Connection Manager on either machine l or w, ... will require changes to the database connection details, ...
    (SSH)