Oracle-Developer.com Forums
A forum for discussing and sharing information about Oracle technologies
 

Navigation: Home  | Discussion Forums  |  Scripts  |  About Us  | Links  | Job Openings  | Blog  
 FAQFAQ   SearchSearch   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Email your Oracle questions to webmaster@oracle-developer.com to get Oracle 11g or Oracle E-Business expert advice.

ORA-01001 invalid cursor

 
Post new topic   Reply to topic    Oracle-Developer.com Forums Forum Index -> Oracle 10g Discussion
View previous topic :: View next topic  
Author Message
vj.jain
Site Admin


Joined: 10 Aug 2007
Posts: 85

PostPosted: Tue Apr 14, 2009 5:27 pm    Post subject: ORA-01001 invalid cursor Reply with quote

ORA-01001 invalid cursor

Cause: Either a host language program call specified an invalid cursor or the value of the MAXOPENCURSORS option in the precompiler command were
too small. All cursors must be opened using the OOPEN call before being
referenced in any of the following calls: SQL, DESCRIBE, NAME, DEFINE,
BIND, EXEC, FETCH, and CLOSE. The Logon Data Area (LDA) must be
defined by using OLON or OLOGON. If the LDA is not defined, this message is issued for the following calls: OPEN, COM, CON, ROL, and LOGOFF.

Action: Check the erroneous call statement.
Specify a correct LDA area or open the cursor as required. If there is no problem with the cursor, it may be necessary to increase the MAXOPENCURSORS option value before precompiling
Back to top
Display posts from previous:   
Post new topic   Reply to topic    Oracle-Developer.com Forums Forum Index -> Oracle 10g Discussion All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Sponsored by Oracle Consulting

Copyright ©2007 Oracle-Developer.com