Home » RDBMS Server » Server Administration » ora-01001 (10gR2, Windows)
ora-01001 [message #304795] Thu, 06 March 2008 13:51 Go to next message
Messages: 205
Registered: January 2007
Senior Member
Hi all,

I have created a database 10gR2 and set the open cursors to 1000. But the remote users are getting ora-01001 invalid cursor error while connecting the database from the application software(which I have not worked with). All I can think of for this error is the max cursor limit and it is set to 1000 already.
Not sure if there is any other fixes for this error.
Any suggestions?

Thank you!
Re: ora-01001 [message #304796 is a reply to message #304795] Thu, 06 March 2008 13:58 Go to previous messageGo to next message
Michel Cadot
Messages: 63911
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
All I can think of for this error is the max cursor limit and it is set to 1000 already.

No this is not the reason.
If the error is "invalid cursor" then you gave an invalid cursor to Oracle.

Re: ora-01001 [message #304866 is a reply to message #304795] Fri, 07 March 2008 00:12 Go to previous message
Messages: 93
Registered: February 2007
Location: Mumbai

You may get this error if you attempted to use cursor before opening it for example doing a %rowcount before opening your cursor. This may also happen if your application is attempting to manipulate data without adhering to limitations and guidelines of your application data provider. I do not Know which provider your application is using in which development environment.


Manjit Kumar [mkbhati]

Previous Topic: Defaulting to Dedicated Server versus Shared Server
Next Topic: another ORA-01591: lock held by in-doubt distributed transaction xx problem
Goto Forum:

Current Time: Sun Oct 23 07:21:53 CDT 2016

Total time taken to generate the page: 0.08540 seconds