Re: ORA 1000 - Max number of cursors exceeded

FYI: Last week I got an an ORA 01000 - "Maximum number of cursors exceeded" error that was very misleading if not incorrect. I shutdown, edited init.ora for many more cursors, restarted and still had the problem. One clue, this error occurred on all of my three Oracle 8.1.5 instances when I tried to run a particular PL/SQL script.

Here is what happened, I imported a bunch of data with Access 97 (Yuk) that had leading spaces in the primary key (varchar2) column. When I discovered this and tried to fix it (without disabling the PK and all FKs) I got the ORA 1000 error. The fix was simple, do the fix with disabled PK and FKs. I have not seen this error since.

Rock Cogar.
Radian International LLC.
Oak Ridge, TN. USA.

In article <5ZcxOFjnZR02JPsVr+4oTaGNZjwE_at_4ax.com>,   jason <jason_at_seahorseNOSPAM.demon.co.uk> wrote:
> On Tue, 16 Nov 1999 17:35:00 +0000, kev <kevin.porter_at_fast.no> wrote:
>
> >Hi,
> >
> >I have a database which is being populated (via PHP web pages) by a
> >couple of people. But that has ground to a halt because all the PHP
> >pages just report an ORA 01000 - "Maximum number of cursors exceeded"
> >error.
> >I have shutdown the DB and restarted it, but this has made no
> >difference. Help! How do I get rid of it?
> >
> >thanks,
> >
> >- Kev
> >
> >
>
> You can add the line OPEN_CURSORS=2000 to your initSID.ora file to
> increase the number of cursors you can open at any one time.
>
> Does anyone know if a cursor that has been opened during a proc. is
> not closed properly, does this leave a handle open? Or are all cursors
> closed implicity at an END; ?
>
> Jason.
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Nov 17 1999 - 07:57:51 CST