ORACLE Database Connection Problem

[dqliang_1]

Hello, everyone,

I'm using Server Side Java Script to connect ORACLE Database. But ORACLE Database display the following error:

ORA-1001, Invalid Cursor

My environment is:
Netscape Enterprise Server 3.6
Livewire Database Service
Server Side JS
ORACLE 7.3.4

If I use sql*plus to connect ORACLE Database, it works.

Who could you give me suggestion?

Thanks,

Holly Liang

[Vincenzo Restuccia]

See http://groups.google.com/groups?hl=en&lr=&safe=off&ic=1&th=d60fc6bb86496593,4&seekm=953322001.23464.0.pluto.d4ee154e%40news.demon.nl#p

[dqliang_1]

Hello,

The following is part of my source code,

database.connect(client.type,
client.server,
client.id,
client.password,
client.database);

The error occurs during database connection phase. I don't think it creates any cursor.


Thanks,

Holly Liang

[John Dixon_1]

Hi,

Check that the value of the OPEN_CURSORS parameter in the Oracle initialization file INIT.ORA is greater than the value of MAXOPENCURSORS. The default value for OPEN_CURSORS is 50.

The following document from metalink lists the common causes of ORA-1001, Invalid Cursor.

http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=1007395.6

cheers,
John