DBD::Oracle question

From: Giovanni Borri (gborri_at_libero.it)
Date: 11/17/04 

To: dbi-users@perl.org
Date: Wed, 17 Nov 2004 18:16:16 +0100

hi Tim,

I have a question for you about the use of DBD::Oracle library.
It's almost 3/4 years that we are using your library to connect to Oracle
database. I this days we are facing a problem and i don't know if it is a
problem of the library or what.
What seems to happen is that when we open a connection to the database and run
some query, after a number of query that we have run seems that we fill the
number of possible cursor per connection. The workaround we have used to not
facing the problem is to open the connection, run a defined number of query
and then close the connection. However this workaround affect the performance
of the database.
Can you please let me know.

Thanks in advance
Giovanni

 

Relevant Pages

  • Re: Ada DB bindings and APQ
    ... >>I didn't like the use of handles for database objects. ... > will ensure that the connection will not go away until at least one query ... > things which can be made with a connection. ... That is different to ODBC. ...
    (comp.lang.ada)
  • RE: Posible to speed up query update with Apllication.screenupdati
    ... Don't change anything on the database side; the only question is the most ... You create a connection by sending the connect string to the ODBC driver. ... (multiple queries). ... You now execute the query (there are several ways in ADO but I usually ...
    (microsoft.public.excel.programming)
  • Re: MS Access looks for .mdb rather than Progress schema
    ... It got past looking for pub.mdb, and looks like it tried to run the query ... I also tried putting the whole thing in the connection string: ... The settings for the Merant ODBC driver for ... default connect string means a jet database. ...
    (microsoft.public.access.modulesdaovba)
  • Re: Word 2003 Closes upon update of sort order of table using Acce
    ... data connection file created to the database folder and created a dummy user ... connection is much faster and seems far more stable. ... incorporate OLE DB, they probably found themselves with a lot more problems ... embed a table or query name. ...
    (microsoft.public.word.mailmerge.fields)
  • Sql Server SCOPE_IDENTITY()
    ... I'm currenly in the process of writing a Database abstraction class ... SCOPE_IDENTITY query it is on the same connection as the INSERT query (which ...
    (microsoft.public.dotnet.framework.adonet)