Hi guy,

Please, have you suggests for my fatal error on oracle DB?


1 : - Error : SQLState QP999: database error 1000 (error 2000)
2 : - Fatal error : Error 2000 (database error 1000) on select
3 : - Fatal error : Can not continue in [sql.fetch]

Could you help me to solve it?

Many thanks.

Lupy

Hi guy,

Please, have you suggests for my fatal error on oracle DB?


1 : - Error : SQLState QP999: database error 1000 (error 2000)
2 : - Fatal error : Error 2000 (database error 1000) on select
3 : - Fatal error : Can not continue in [sql.fetch]

Could you help me to solve it?

Many thanks.

Lupy

Hello,

Oracle error : '1000 ORA-01000: maximum open cursors exceeded

Regards

CAN ANY ONE LET ME KNOW HOW DATABASE ERROR 1000 CAN BE FIXED ?
I AM USING DYNAMIC SQL IN RECURSIVE FUNCTION BUT FOR EACH FETCHED QUERY DONE I CLOSE THE QUERY WITH sql.close(qry.id) and qry.id=0.

INSPITE OF CLOSING I STILL GET ERROR 2000.

IS THERE ANYTHING ELSE I HAVE MISSED?
PLEASE HELP!!

CAN ANY ONE LET ME KNOW HOW DATABASE ERROR 1000 CAN BE FIXED ?
I AM USING DYNAMIC SQL IN RECURSIVE FUNCTION BUT FOR EACH FETCHED QUERY DONE I CLOSE THE QUERY WITH sql.close(qry.id) and qry.id=0.

INSPITE OF CLOSING I STILL GET ERROR 2000.

IS THERE ANYTHING ELSE I HAVE MISSED?
PLEASE HELP!!

Hello,
The initialization parameter OPEN_CURSORS in INITSID.ORA/ SPFILE determines the maximum number of cursors per session.

Check the parameter specified by executing the following SQL:
select * from v$parameter
where name = 'open_cursors'
/

If you want more cursors to be opened at the same time, shut the database, change INITSID.ORA or SPFILE and restart the database.

You can find the list of open and opened cursors and the users who opened them by executing the following SQL:

select user_name, status, osuser, machine, a.sql_text
from v$session b,
v$open_cursor a
where a.sid = b.sid
/

The following SQL will tell you the number of currently open sessions and the SID of each session currently connected to your database:

select sid, value
from v$sesstat sest
where statistic# = 3
order by value desc
/

Regards