> > Dear Stefan,
> >
> > Thanks for your reply.
> > You are right I also have just tested what you have mentioned above.
> > Can you please confirm me one thing if you open a cursor and don't close
> > the cursor will it effect the memory?? it is becuase in multi users envirnment
> > procedure will be called many time a day.
> >
>
> Hi Malik -
>
> Oracle seems to do some garabage collection on its own, in addition those "package" cursors get closed even immediately when the demanding client disconnects. The latter is what we do intensively at runtime anyway, so there were never any "too man cursor" issues here.
>
>
> hth
> -Stefan
thanks a lot.
I have started working on it. I shall ask you if I face any problem.