Re: Equivalent of hold cursor in pl/sql

try commit after closing the cursor for each fid so that all the resources are freed. I am not sure commit work release is supported in pl/sql

narenn_at_my-dejanews.com wrote:

> I wrote a small package with fetches rows in a table.
> The pseudo code looks like this
>
> procedure abc ( fi_id in number ) is
> cursor xyz is select .................
> begin
> open xyz;
> loop
> fetch xyz into ....
> exit when not found;
> end loop;
> close xyz;
> end abc;
>
> loop for a list of fi_id's
> package.abc(current fi_id);
> end loop;
>
> This takes too much time. Looks like the open/close cursor every time is
> eating up lots of resources. I cannot do one fetch because the list of fi_id
> could be random. How do i do something like hold_cursor in pl/sql. I have
> done this is proc*c or oci. Any ideas ?
>
> Thanks
>
> -Naren
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Mon May 24 1999 - 09:58:58 CDT