var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: There's no current cursor - Error
I'v an application that open one conection inside one while and close it a each interaction, for example:
While i=0 to 500
Begin '' Start Transaction
. (Several operations like Inserts, Updates, Deletes etc)
Commit '' End Transaction
When I'v a small count (variable I) example: 100, the application work perfectly.
The problem occours when I try 500,600 interactions, appearing the error:"There's no current cursor "
I guess there are any configuration in onconfig, because I'm beliving that informix's droping connecting of my application for own "security"
Someone knows a way solve this problem ?
I tried open just one connection and open and close transactiosn in each interaction, but the result was worse.
I was thinking about my problem. I'v a blob field system on that operation.. and I'm beliving the problem occour because I'v to record text field (blob) at each interaction and maybe it generate error...
I was reading onconfig parameters and I saw DBSPACETEMP PHYSFILE TEMPS...
If I changed that parameters, can help in a problem ?
did you check about eventual cursors that should remain opened while you perform the transactions?
Commit/rollback will close all open cursors unless they are DECLARED as WITH HOLD.
Dis you check this ?
Did you examined about ultimate cursors that should stay started out while you execute the transactions.
Last edited by Steffanblue; 09-02-13 at