Re: ORA-01000

From: Dan Benwell <dan_at_benwell.co.uk>
Date: Sat, 21 Aug 1999 21:25:46 +0100
Message-ID: <7pn1vc$m1$1@lure.pipex.net>

Have you set open_cursors in init.ora

I think that I am right in saying that open_cursors is database wide where as maxopencursors is on a session/process basis. Set open_cursors=1000 in init.ora and restart the instance.

Dan
S Gentley <sgentely_at_mediaone.net> wrote in message news:maDv3.1907$a_.52299_at_wbnws01.ne.mediaone.net...
> I have maxopencursors set to 1000 and still get the ORA-1000 error. The
> application running is a form which has a button that will update some
rows
> and insert new rows into 2 tables. Each table has a database trigger. In
> the triggers the various select statements coded for validation of data
were
> implicit selects. I modified all selects so I could open, fetch then
close
> them. This did not make any difference. As long as the user stays in the
> applicaton, the new cursors opened are added to the old cursors already
> opened. I checked this by looking in V$OPEN_CURSORS and after each
> transaction the user did new entries were placed here. Running 8.0.4 on a
> DEC Unix platform.
>
> Does anyone have other ideas which would close the cursors.
>
> Thanks
>
>
Received on Sat Aug 21 1999 - 15:25:46 CDT