Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

[Help]SQL0501-Cursor CRSR0004 not open

 
Eung maeng
Ranch Hand
Posts: 68
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi guys,
I need you guy's help to solve this error "QL0501 - Cursor CRSR0004 not open"
Does anyone have a same error before?
Please send a mail as soon as possible. It would be greatly appreciated.
look forward to hearing from you soon.
sincerely,
paul maeng
paul.maeng@intentia.com.au
 
Jamie Robertson
Ranch Hand
Posts: 1879
MySQL Database Suse
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Please, post your answers here so that someone else can find the answer when searching the forum.
With that said, you'll need to be more specific in your question for a more accurate answer. Information that would help:
1. database vendor (Oracle, MySQL, MSSQL...)
2. driver ( Oracle thin, merant, ODBC bridge...)
3. post a code snippet of the problem area ( use the "Instant UBB Code" tags below to help format your code ) identifying the line throwing the error.

Jamie
 
Avi Abrami
Ranch Hand
Posts: 1141
1
Java Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Paul,
This is a wild guess -- based on, as Jamie says, the [incredible lack of] information you have provided.
You have "close()"d your "ResultSet", and then you are trying to do something with it (like "next()" or "getObject()"). Once you have invoked the "close()" method, you cannot do anything more with it.
Apart from the details that Jamie has suggested you supply, I think the entire error message and accompanying stack trace would also help.
Good Luck,
Avi.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic