Re: Strange problem in declaring cursor..

cartoon wrote:

> 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..!!!

And without giving us any code to look at, not the version and edition of Oracle, not the product you are working with, or any other information you expect help?

Here's what you get:

http://tahiti.oracle.com
http://otn.oracle.com
http://asktom.oracle.com
http://www.google.com

Have at it! ;-)

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)