Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Patch of the day??
This is a multi-part message in MIME format.
--Boundary_(ID_RhBjDz47vkQDSbRStwwthg)
Content-type: text/plain; charset=iso-8859-1
Content-transfer-encoding: quoted-printable
For the first time when I create the procedure from script, then it is = fine, after that any number of time I recompile it using alter command, = then it stay in reverse order. One more interesting thing I noticed = was, Using SQl*Plus 3.x, it displays correctly, may be bug in SQl*Net or = in OCI Libs.
does the order become same if recompile it twice ?
=20
ajay
RE: Patch of the day??Right now in 8.1.6, we are facing a bug (# = 782989), which is just reversing the order of the arguments in = procedure/function after we recompile them using the alter command or = Oracle compiles to validate them. There is no pactch and Oracle said, = it will be fixed in 8.1.7.
Hi Rodd,=20
We've been running 8.1.6.2 on HP/UX 11.0 32- and 64-bit with no = serious problems. One fixed bug bit us, but that was it. Upgrading the = database itself was painful, but after the upgrade completed, the = database and the code ran (and still runs) fine.=20
HTH=20
Lisa Rutland Koivu=20 Oracle Database Administrator=20 Qode.com=20 4850 North State Road 7=20 Suite G104=20 Fort Lauderdale, FL 33319=20 V: 954.484.3191, x174=20 F: 954.484.2933=20 C: 954.658.5849=20 http://www.qode.com=20 "The information contained herein does not express the opinion or =position of Qode.com and cannot be attributed to or made binding upon = Qode.com."
-----Original Message-----=20 From: Holman, Rodney [mailto:rodney.holman_at_lodgenet.com]=20 Sent: Thursday, October 26, 2000 1:52 PM=20 To: Multiple recipients of list ORACLE-L=20 Subject: Patch of the day??=20 Help the patches are getting to me!!!=20 I am working on migrating a system from 8.0.5.1 to 8i (HP-UX 11.0 = 32Bit).=20 I have installed 8.1.6, am downloading 8.1.6.2.1 patchset (it's = listed as=20 8.1.6.2.0 on Metalink I checked with them this AM).=20 While on the phone with the support folks they told me I should be = going to=20 8.1.7.=20 8.1.6 has been patched 4 times in 3 months with fairly major = patches (by=20 looking at the readme's), and is now being superseeded with 8.1.7. = Do I=20 even want to continue with 8.1.6.x or should I wait for the 8.1.7 = to arrive=20 and go with it? Do any of you have expierence with either/both? =Any ideas?=20
I'm under some time constraints to get this tested and implemented = by Nov=20
15th.=20
Rodd Holman=20 Enterprise Data Systems Engineer=20 LodgeNet Entertainment Corporation=20 rodney.holman_at_lodgenet.com=20 --=20 Please see the official ORACLE-L FAQ: http://www.orafaq.com=20 --=20 Author: Holman, Rodney=20 INET: rodney.holman_at_lodgenet.com=20 Fat City Network Services -- (858) 538-5051 FAX: (858) = 538-5051=20 San Diego, California -- Public Internet access / Mailing = Lists =subscribing).=20
--------------------------------------------------------------------=20
To REMOVE yourself from this mailing list, send an E-Mail message=20 to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and = in=20 the message BODY, include a line containing: UNSUB ORACLE-L=20 (or the name of mailing list you want to be removed from). You = may=20 also send the HELP command for other information (like =
--Boundary_(ID_RhBjDz47vkQDSbRStwwthg)
Content-type: text/html; charset=iso-8859-1
Content-transfer-encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META content=3D"text/html; charset=3Diso-8859-1" =http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.2014.210" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#ffffff> <DIV><FONT face=3DArial size=3D2>For the first time when I create the =procedure from=20
<DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>ajay</FONT></DIV> <BLOCKQUOTE=20
<DIV style=3D"FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV=20
style=3D"BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: =
black"><B>From:</B>=20
<A href=3D"mailto:bala.subramanian_at_wcom.com"=20 title=3Dbala.subramanian_at_wcom.com>Balakrishnan Subramanian</A> = </DIV>
<DIV style=3D"FONT: 10pt arial"><B>To:</B> <A=20 href=3D"mailto:ORACLE-L_at_fatcity.com" = title=3DORACLE-L_at_fatcity.com>Multiple=20
recipients of list ORACLE-L</A> </DIV> <DIV style=3D"FONT: 10pt arial"><B>Sent:</B> Thursday, October 26, = 2000 4:56=20
PM</DIV>
<DIV style=3D"FONT: 10pt arial"><B>Subject:</B> Re: Patch of the =
day??</DIV>
<DIV><BR></DIV>RE: Patch of the day??Right now in 8.1.6, we are = facing a bug=20
(# 782989), which is just reversing the order of the arguments in=20 procedure/function after we recompile them using the alter command = or Oracle=20
compiles to validate them. There is no pactch and Oracle said, = it will=20
be fixed in 8.1.7.<BR> ----- Original Message ----- <BR> = From:=20
Koivu, Lisa <BR> To: Multiple recipients of list ORACLE-L = <BR> =20
Sent: Thursday, October 26, 2000 3:51 PM<BR> Subject: RE: = Patch of the=20
day??<BR><BR><BR> Hi Rodd, <BR><BR> We've been running = 8.1.6.2=20
on HP/UX 11.0 32- and 64-bit with no serious problems. One = fixed bug=20
bit us, but that was it. Upgrading the database itself was = painful,=20
but after the upgrade completed, the database and the code ran (and = still=20
runs) fine. <BR><BR> HTH <BR><BR> Lisa Rutland Koivu = <BR> =20
Oracle Database Administrator <BR> Qode.com <BR> 4850 = North=20
State Road 7 <BR> Suite G104 <BR> Fort Lauderdale, = FL =20
33319 <BR><BR> V: 954.484.3191, x174 <BR> F: = 954.484.2933=20
<BR> C: 954.658.5849 <BR> http://www.qode.com = <BR><BR> =20
"The information contained herein does not express the opinion or = position=20
of Qode.com and cannot be attributed to or made binding upon=20 Qode.com."<BR><BR><BR><BR> -----Original Message----- = <BR> From:=20
Holman, Rodney [mailto:rodney.holman_at_lodgenet.com] <BR> Sent:=20 Thursday, October 26, 2000 1:52 PM <BR> To: Multiple = recipients of=20
list ORACLE-L <BR> Subject: Patch of the day?? = <BR><BR><BR><BR> =20
Help the patches are getting to me!!! <BR><BR> I am working on =
migrating a system from 8.0.5.1 to 8i (HP-UX 11.0 32Bit). <BR> = I have=20
installed 8.1.6, am downloading 8.1.6.2.1 patchset (it's = listed as=20
<BR> 8.1.6.2.0 on Metalink I checked with them this AM). = <BR> =20
While on the phone with the support folks they told me I should be = going to=20
<BR> 8.1.7. <BR><BR> 8.1.6 has been patched 4 = times in 3=20
months with fairly major patches (by <BR> looking at the = readme's),=20
and is now being superseeded with 8.1.7. Do I <BR> even = want to=20
continue with 8.1.6.x or should I wait for the 8.1.7 to arrive = <BR> =20
and go with it? Do any of you have expierence with = either/both? =20
Any ideas? <BR><BR> I'm under some time constraints to get = this tested=20
and implemented by Nov <BR> 15th. <BR><BR> Rodd Holman=20 <BR> Enterprise Data Systems Engineer <BR> LodgeNet=20 Entertainment Corporation <BR> rodney.holman_at_lodgenet.com=20 <BR><BR> -- <BR> Please see the official ORACLE-L FAQ:=20 http://www.orafaq.com <BR> -- <BR> Author: Holman, = Rodney=20
<BR> INET: rodney.holman_at_lodgenet.com = <BR><BR> Fat=20
City Network Services -- (858) 538-5051 FAX: = (858)=20
538-5051 <BR> San Diego,=20
California -- Public =
Internet=20
access / Mailing Lists<BR> =20
<BR> To REMOVE yourself from this mailing list, send an E-Mail = message=20
<BR> to: ListGuru_at_fatcity.com (note EXACT spelling of = 'ListGuru') and=20
in <BR> the message BODY, include a line containing: UNSUB =
ORACLE-L=20
<BR> (or the name of mailing list you want to be removed =
Received on Fri Oct 27 2000 - 08:09:54 CDT