Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Patch of the day??

Re: Patch of the day??

From: Balakrishnan Subramanian <bala.subramanian_at_wcom.com>
Date: Fri, 27 Oct 2000 08:09:54 -0500
Message-Id: <10662.120427@fatcity.com>


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
      =

--------------------------------------------------------------------=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 =
subscribing).=20

--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
script, then it is fine, after that any number of time I recompile it = using=20
alter command, then it stay in reverse order.&nbsp; One more interesting = thing I=20
noticed was, Using SQl*Plus 3.x, it displays correctly, may be bug in = SQl*Net or=20
in OCI Libs.</FONT></DIV>
<BLOCKQUOTE=20
style=3D"BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: = 0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px">   <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:ajay_at_tems.com" title=3Dajay_at_tems.com>Ajay K</A> = </DIV>
  <DIV style=3D"FONT: 10pt arial"><B>To:</B> <A = href=3D"mailto:ORACLE-L_at_fatcity.com"=20
  title=3DORACLE-L_at_fatcity.com>Multiple recipients of list ORACLE-L</A> = </DIV>
  <DIV style=3D"FONT: 10pt arial"><B>Sent:</B> Thursday, October 26, = 2000 6:35=20
  PM</DIV>
  <DIV style=3D"FONT: 10pt arial"><B>Subject:</B> Re: Patch of the = day??</DIV>
  <DIV><BR></DIV>
  <DIV><FONT face=3DArial size=3D2>does the order become same if = recompile it twice=20
  ?</FONT></DIV>
  <DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
  <DIV><FONT face=3DArial size=3D2>ajay</FONT></DIV>
  <BLOCKQUOTE=20

  style=3D"BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; = MARGIN-RIGHT: 0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px">

    <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.&nbsp; There is no pactch and Oracle said, = it will=20

    be fixed in 8.1.7.<BR>&nbsp; ----- Original Message ----- <BR>&nbsp; = From:=20

    Koivu, Lisa <BR>&nbsp; To: Multiple recipients of list ORACLE-L = <BR>&nbsp;=20

    Sent: Thursday, October 26, 2000 3:51 PM<BR>&nbsp; Subject: RE: = Patch of the=20

    day??<BR><BR><BR>&nbsp; Hi Rodd, <BR><BR>&nbsp; We've been running = 8.1.6.2=20

    on HP/UX 11.0 32- and 64-bit with no serious problems.&nbsp; One = fixed bug=20

    bit us, but that was it.&nbsp; 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>&nbsp; HTH <BR><BR>&nbsp; Lisa Rutland Koivu = <BR>&nbsp;=20

    Oracle Database Administrator <BR>&nbsp; Qode.com <BR>&nbsp; 4850 = North=20

    State Road 7 <BR>&nbsp; Suite G104 <BR>&nbsp; Fort Lauderdale, = FL&nbsp;=20

    33319 <BR><BR>&nbsp; V: 954.484.3191, x174 <BR>&nbsp; F: = 954.484.2933=20

    <BR>&nbsp; C: 954.658.5849 <BR>&nbsp; http://www.qode.com = <BR><BR>&nbsp;=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>&nbsp; -----Original Message----- = <BR>&nbsp; From:=20

    Holman, Rodney [mailto:rodney.holman_at_lodgenet.com] <BR>&nbsp; Sent:=20     Thursday, October 26, 2000 1:52 PM <BR>&nbsp; To: Multiple = recipients of=20

    list ORACLE-L <BR>&nbsp; Subject: Patch of the day?? = <BR><BR><BR><BR>&nbsp;=20

    Help the patches are getting to me!!! <BR><BR>&nbsp; I am working on =

    migrating a system from 8.0.5.1 to 8i (HP-UX 11.0 32Bit). <BR>&nbsp; = I have=20

    installed 8.1.6, am downloading&nbsp; 8.1.6.2.1 patchset (it's = listed as=20

    <BR>&nbsp; 8.1.6.2.0 on Metalink I checked with them this AM). = <BR>&nbsp;=20

    While on the phone with the support folks they told me I should be = going to=20

    <BR>&nbsp; 8.1.7. <BR><BR>&nbsp; 8.1.6 has been patched&nbsp; 4 = times in 3=20

    months with fairly major patches (by <BR>&nbsp; looking at the = readme's),=20

    and is now being superseeded with 8.1.7.&nbsp; Do I <BR>&nbsp; even = want to=20

    continue with 8.1.6.x or should I wait for the 8.1.7 to arrive = <BR>&nbsp;=20

    and go with it?&nbsp; Do any of you have expierence with = either/both?&nbsp;=20

    Any ideas? <BR><BR>&nbsp; I'm under some time constraints to get = this tested=20

    and implemented by Nov <BR>&nbsp; 15th. <BR><BR>&nbsp; Rodd Holman=20     <BR>&nbsp; Enterprise Data Systems Engineer <BR>&nbsp; LodgeNet=20     Entertainment Corporation <BR>&nbsp; rodney.holman_at_lodgenet.com=20     <BR><BR>&nbsp; -- <BR>&nbsp; Please see the official ORACLE-L FAQ:=20     http://www.orafaq.com <BR>&nbsp; -- <BR>&nbsp; Author: Holman, = Rodney=20

    <BR>&nbsp;&nbsp;&nbsp; INET: rodney.holman_at_lodgenet.com = <BR><BR>&nbsp; Fat=20

    City Network Services&nbsp;&nbsp;&nbsp; -- (858) 538-5051&nbsp; FAX: = (858)=20

    538-5051 <BR>&nbsp; San Diego,=20
    California&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -- Public = Internet=20

    access / Mailing Lists<BR>&nbsp;=20

    <BR>&nbsp; To REMOVE yourself from this mailing list, send an E-Mail = message=20

    <BR>&nbsp; to: ListGuru_at_fatcity.com (note EXACT spelling of = 'ListGuru') and=20

    in <BR>&nbsp; the message BODY, include a line containing: UNSUB = ORACLE-L=20
    <BR>&nbsp; (or the name of mailing list you want to be removed = Received on Fri Oct 27 2000 - 08:09:54 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US