Re: maximum open cursors exceeded

From: Ragnar Henriksen <ragnar.henriksen_at_novit.no>
Date: 1997/11/14
Message-ID: <64gvcc$4t1$1@o.online.no>#1/1

jennifer wrote in message <346B9C52.167E_at_webvision.com>...
>Looking for a fix or some sort of workaround.
>When trying to delete from a table I receive this error:
>
>ORA-01000: maximum open cursors exceeded
>
>Has anyone else encountered this?
>
>Thanks,
>jennifer

In your pfile put this attribute:

open_cursors = <numbers of cursors>

Default is 50.

(Remember to restart ORACLE)

--
Ragnar Henriksen
Systems Consultant

Received on Fri Nov 14 1997 - 00:00:00 CST