Re: Equivalent of hold cursor in pl/sql

Hi Naren

Afaik this can only be remedied by increasing (or usually setting) the underdocumented init<sid>.ora parameter session_cached_cursors to a non-zero number. Fifty seems to work fine.

Hth,

Sybrand Bakker, Oracle DBA

narenn_at_my-dejanews.com wrote in message <7flb3r$ni3$1_at_nnrp1.dejanews.com>...
>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 Wed Apr 21 1999 - 16:14:46 CDT