topic Re: ORACLE Database Connection Problem in Operating System - HP-UX

ORACLE Database Connection Problem

dqliang_1 — Thu, 17 May 2001 09:59:20 GMT

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

Re: ORACLE Database Connection Problem

Vincenzo Restuccia — Thu, 17 May 2001 10:15:12 GMT

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

Re: ORACLE Database Connection Problem

dqliang_1 — Thu, 17 May 2001 10:41:53 GMT

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

Re: ORACLE Database Connection Problem

John Dixon_1 — Fri, 18 May 2001 08:50:48 GMT

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