Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

ORACLE Database Connection Problem

dqliang_1
Occasional Contributor

ORACLE Database Connection Problem

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
3 REPLIES
Vincenzo Restuccia
Honored Contributor
dqliang_1
Occasional Contributor

Re: ORACLE Database Connection Problem

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
Advisor

Re: ORACLE Database Connection Problem

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