| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 8.1.6.- from 32 to 64
Hi,
is there a problem with switching from 32bit Oracle 8.1.6 to 64bit (HP and SPARC) and back? Could it be done on the same datafiles (i.e. is there a differences in file formats or anything else)?
TIA,
Uldis
Uldis Pavuls
DBA, Tieto Konts Financial Systems Ltd.
Kr.Barona 32, Riga, Latvia, LV 1011
phone +371 7 286 660, fax +371 7 243 000
mailto:U.Pavuls@konts.lv, http://www.konts.lv
From: "Peter Hazelton" <peterhazelton_at_hotmail.com>
Date: Fri, 08 Sep 2000 14:07:01 GMT
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.
From: "Armstead, Michael A" <maa25681_at_glaxowellcome.com>
Date: Fri, 8 Sep 2000 10:11:38 -0400
Subject: RE: urgent!!!!!!!!!
I agree with Lisa. You probably need to do a recovery.
Call Oracle Support immediately!!!
Michael Armstead
Database Administrator, OCP-Certified
Corporate & Finance Information Systems
Glaxo Wellcome
> -----Original Message-----
> From: Galleri, Mariana [SMTP:MGalleri_at_uniFON.com.ar]
> Sent: Friday, September 08, 2000 3:45 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: urgent!!!!!!!!!
>
> It seems a disk error. Did you check the disks?
>
>
> -----Mensaje original-----
> De: Slavica Sadzakovic [mailto:sslavica_at_dkts.co.yu]
> Enviado el: Viernes 8 de Septiembre de 2000 04:00
> Para: Multiple recipients of list ORACLE-L
> Asunto: urgent!!!!!!!!!
>
>
> What I have to do ?
>
> Thu Sep 7 09:39:04 2000
> LGWR: prodding the archiver
> Thread 1 advanced to log sequence 7661
> Current log# 4 seq# 7661 mem# 0: /oracle/u04/oradata/telispro/redo04.log
> Current log# 4 seq# 7661 mem# 1:
> /export/home/oracle/oradata/telispro/redo04b.log
> Thu Sep 7 09:39:04 2000
> ARC0: received prod
> ARC0: Beginning to archive log# 3 seq# 7660
> ARC0: Completed archiving log# 3 seq# 7660
> ARC0: re-scanning for new log files
> ARC0: prodding the archiver
> ARC0: received prod
> Thu Sep 7 10:50:17 2000
> LGWR: prodding the archiver
> Thread 1 advanced to log sequence 7662
> Current log# 2 seq# 7662 mem# 0: /oracle/u04/oradata/telispro/redo02.log
> Current log# 2 seq# 7662 mem# 1:
> /export/home/oracle/oradata/telispro/redo02b.log
> Thu Sep 7 10:50:17 2000
> ARC0: received prod
> ARC0: Beginning to archive log# 4 seq# 7661
> ARC0: Completed archiving log# 4 seq# 7661
> ARC0: re-scanning for new log files
> ARC0: prodding the archiver
> ARC0: received prod
> Thu Sep 7 11:26:57 2000
> LGWR: prodding the archiver
> Thread 1 advanced to log sequence 7663
> Current log# 1 seq# 7663 mem# 0: /oracle/u04/oradata/telispro/redo01.log
> Thu Sep 7 11:26:57 2000
> Current log# 1 seq# 7663 mem# 1:
> /export/home/oracle/oradata/telispro/redo01b.log
> Thu Sep 7 11:26:57 2000
> ARC0: received prod
> Thu Sep 7 11:26:57 2000
> ARC0: Beginning to archive log# 2 seq# 7662
Received on Fri Sep 08 2000 - 07:59:55 CDT
 |
 |