What's wrong with this cursor???

From: Peter Hazelton <peterhazelton_at_hotmail.com>
Date: Fri, 08 Sep 2000 14:07:01 GMT
Message-Id: <10613.116509@fatcity.com>

Hi all

I have created the following in Oracle Reports:

function CF_25_percentFormula return Number is total_rec number(9);
v_counter number(9) :=0;
v_icons inpatient.icons%type;
twenty_five_perc_rec number(9);

cursor this_cursor is
  select icons
  from inpatient
  where icons < 100;

begin
select count(icons)
into total_rec
from inpatient
where icons <=100;
twenty_five_perc_rec := total_rec*.25 ;
loop
open this_cursor;
fetch this_cursor into v_icons;
v_counter := v_counter +1;

if v_counter = twenty_five_perc_rec then return(v_icons); end if;
exit when this_cursor%NOTFOUND;
end loop;
close this_cursor;
END; The function compiles fine, but when I go to run it, I get the following error:
ORA_06511: PL/SQL: cursor already open.

Am I close with this function? I am looking to return the ICONS number for the 25th percentile record.

Thanks in advance for your help.

Peter

---

Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

Share information about yourself, create your own public profile at Received on Fri Sep 08 2000 - 09:07:01 CDT