OraFAQ Forum: Forms » Help For Error Code

Home » Developer & Programmer » Forms » Help For Error Code

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Help For Error Code [message #266220]

Mon, 10 September 2007 04:09

alijeyan
Messages: 184
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

Report message to a moderator

Re: Help For Error Code [message #266226 is a reply to message #266220]

Mon, 10 September 2007 04:25

Littlefoot
Messages: 21818
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.

Report message to a moderator

Re: Help For Error Code [message #267314 is a reply to message #266226]

Thu, 13 September 2007 00:47

alijeyan
Messages: 184
Registered: January 2007
Location: IRAN

Senior Member

ThanQ LitteFoot

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 27 04:24:34 CDT 2024