Home » Developer & Programmer » Forms » Help For Error Code
Help For Error Code [message #266220] Mon, 10 September 2007 04:09 Go to next message
alijeyan
Messages: 180
Registered: January 2007
Location: IRAN
Senior Member
Hi all freinds

I have an application with 50 form and 200 report .
my APP. worked good .

I design an simple report but when i try run report from My
App. Main Menu , i see the folowing error randomly.

ORA -01000 - Maximum Open cursors exceeded .

when error ocoured i quit from App and return . report Run Good !

Thanks

Re: Help For Error Code [message #266226 is a reply to message #266220] Mon, 10 September 2007 04:25 Go to previous messageGo to next message
Littlefoot
Messages: 20900
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Oracle
ORA-01000 maximum open cursors exceeded

Cause: A host language program attempted to open too many cursors. The initialization parameter OPEN_CURSORS determines the maximum number of cursors per user.

Action: Modify the program to use fewer cursors. If this error occurs often, shut down Oracle, increase the value of OPEN_CURSORS, and then restart Oracle.
Re: Help For Error Code [message #267314 is a reply to message #266226] Thu, 13 September 2007 00:47 Go to previous message
alijeyan
Messages: 180
Registered: January 2007
Location: IRAN
Senior Member
ThanQ LitteFoot

Previous Topic: how to show multiple records in a grid according to condition
Next Topic: Concurrent program unable to pick parameter from DB
Goto Forum:
  


Current Time: Thu Dec 08 12:38:49 CST 2016

Total time taken to generate the page: 0.08542 seconds