Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: What's wrong with this cursor???
Peter,
Open your cursor before the loop:
open this_cursor;
loop
fetch this_cursor into v_icons; exit when this_cursor%NOTFOUND; v_counter := v_counter +1; if v_counter = twenty_five_perc_rec then return(v_icons); end if; end loop; close this_cursor;
David A. Barbour
Oracle DBA - ConnectSouth
512-681-9438
dbarbour_at_connectsouth.com
-----Original Message-----
From: Peter Hazelton [mailto:peterhazelton_at_hotmail.com]
Sent: Friday, September 08, 2000 10:47 AM
To: Multiple recipients of list ORACLE-L
Subject: What's wrong with this cursor???
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
Share information about yourself, create your own public profile at http://profiles.msn.com.
-- Author: Peter Hazelton INET: peterhazelton_at_hotmail.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You mayReceived on Fri Sep 08 2000 - 16:00:06 CDT
![]() |
![]() |