Re: ORA-01000 maximum open cursors exceeded
From: <sybrandb_at_yahoo.com>
Date: 10 Dec 2003 00:33:51 -0800
Message-ID: <a1d154f4.0312100033.4668179_at_posting.google.com>
Date: 10 Dec 2003 00:33:51 -0800
Message-ID: <a1d154f4.0312100033.4668179_at_posting.google.com>
"Dan White" <dan_at_omegaconcepts.net> wrote in message news:<exvBb.5294$UM4.1322_at_nwrdny01.gnilink.net>...
> Deepali ,
>
> I would select your results into a java object(i.e.hash table) in a
> serverlet then close the cursor.
>
>
Which is obviously a completely undesirable solution as you won't see
any changes to the table anymore. The OP just needs to increase the
init.ora parameter open_cursors and bounce the database.
I would strongly urge you to learn something about relational
databases.
Sybrand Bakker
Senior Oracle DBA
Received on Wed Dec 10 2003 - 09:33:51 CET