Search:

Type: Posts; User: magher

Search: Search took 0.45 seconds.

  1. Replies
    9
    Views
    314

    Re: Oracle cursor will not close

    Hi,

    Thank you all. The problem was mainly some seriously damaged braincells on my side, and and a few bugs in the code. It works now, case is solved (the code anyways) and I will be back with an...
  2. Replies
    9
    Views
    314

    Re: Oracle cursor will not close

    The cursors do close when I close the connection.

    I tried to perform an explicit garbage collection but with no result.

    --- Update ---



    I monitor the open cursors in the database and they...
  3. Replies
    9
    Views
    314

    Re: Oracle cursor will not close

    Since I'm a newbie at Java I'm not shure. I read somewhere that it can make a difference to close the statement first and then the resultset. I tried to use something like...



    conn (connection...
  4. Thread: Hi,

    by magher
    Replies
    3
    Views
    126

    Re: Hi,

    Thanks :)
  5. Replies
    9
    Views
    314

    Oracle cursor will not close

    Hi,

    I read some data from an Oracle database using a package with a number of functions and refcursors to produce the result sets. The database is read periodicaly via a timer and presented on...
  6. Thread: Hi,

    by magher
    Replies
    3
    Views
    126

    Hi,

    I'm an old school programmer that wants to learn something 'new' so I thought Java was interesting.

    I work as a senior Oracle DBA and code mainly in PL/SQL. In my work I have developed lots of...
Results 1 to 6 of 7