Re: Strange problem in declaring cursor..

I found the reason of the problem I posted..

In the application code, I checked the sqlca.sqlcode to inspect the result..

But I didn't know that declaring cursor doesn't make any change to it..

Well.. I checked it after declaring cursor and it returned the unpredictable values

causing application failure..

So.. I made the app to run by checking sqlcode after opening cursor and sqlca initialization..

Bye~

"cartoon" <cartoon_at_bbs.kmu.ac.kr> wrote in message news:bcgt2f$3m8$1_at_news1.kornet.net...
> Hi.. I want to make question for some problem I can't understand..
>
> I made a multi-threaded application that each thread connect on database
and
> fetch records from it using cursor..
>
> The problem is that it fails to declare cursor from time to time but not
all
> the times..
>
> Anyway.. It was solved by COMMITting for each working transaction..
>
> Is there anybody let me know the reason why that happens...??
>
> Thanks in advance..!!!
>
>
>
>
Received on Mon Jun 16 2003 - 23:45:56 CDT