Re: ORA-01000 + DESIGNER 2000

CDJ wrote:
>
> Get the following error messages from the Application Design Wizard :
>
> Inserting candidate modules......
> ORA-00604: error occurred at recursive SQL level 1
> ORA-01000: maximum open cursors exceeded
> ORA-01000: maximum open cursors exceeded
> ORA-01000: maximum open cursors exceeded
> DESIGNER/2000 location(10104)
> DESIGNER/2000 location(10104)
> ORA-00603: ORACLE server session terminated by fatal error
> ORA-00603: ORACLE server session terminated by fatal error
> NOLONG
> NOLONG
> DESIGNER/2000 location(10019)
>
> Is ther a parameter in the DB that can be modified(add more cursors?) to
> solve this problem?
>
> TIA
>
> djjr_at_ix.netcom.com
locate your init____.ora file and include in it the following entry:-

open_cursors=200

Afterwards, shutdown your database and restart it Received on Tue Jul 23 1996 - 00:00:00 CEST