Message-Id: <10662.120427@fatcity.com> From: Balakrishnan Subramanian Date: Fri, 27 Oct 2000 08:09:54 -0500 Subject: 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. ----- Original Message -----=20 From: Ajay K=20 To: Multiple recipients of list ORACLE-L=20 Sent: Thursday, October 26, 2000 6:35 PM Subject: Re: Patch of the day?? does the order become same if recompile it twice ? =20 ajay ----- Original Message -----=20 From: Balakrishnan Subramanian=20 To: Multiple recipients of list ORACLE-L=20 Sent: Thursday, October 26, 2000 4:56 PM Subject: Re: Patch of the day?? 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. ----- Original Message -----=20 From: Koivu, Lisa=20 To: Multiple recipients of list ORACLE-L=20 Sent: Thursday, October 26, 2000 3:51 PM Subject: RE: Patch of the day?? 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@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@lodgenet.com=20 --=20 Please see the official ORACLE-L FAQ: http://www.orafaq.com=20 --=20 Author: Holman, Rodney=20 INET: rodney.holman@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@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
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.  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.
----- Original Message -----
From:=20 Ajay K =
To: Multiple recipients of list ORACLE-L =
Sent: Thursday, October 26, = 2000 6:35=20 PM
Subject: Re: Patch of the = day??

does the order become same if = recompile it twice=20 ?
 
ajay
----- Original Message -----
From:=20 Balakrishnan Subramanian =
To: Multiple=20 recipients of list ORACLE-L
Sent: Thursday, October 26, = 2000 4:56=20 PM
Subject: Re: Patch of the = day??

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.
  ----- Original Message -----
  = From:=20 Koivu, Lisa
  To: Multiple recipients of list ORACLE-L =
 =20 Sent: Thursday, October 26, 2000 3:51 PM
  Subject: RE: = Patch of the=20 day??


  Hi Rodd,

  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.

  HTH

  Lisa Rutland Koivu =
 =20 Oracle Database Administrator
  Qode.com
  4850 = North=20 State Road 7
  Suite G104
  Fort Lauderdale, = FL =20 33319

  V: 954.484.3191, x174
  F: = 954.484.2933=20
  C: 954.658.5849
  http://www.qode.com =

 =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."



  -----Original Message----- =
  From:=20 Holman, Rodney [mailto:rodney.holman@lodgenet.com]
  Sent:=20 Thursday, October 26, 2000 1:52 PM
  To: Multiple = recipients of=20 list ORACLE-L
  Subject: Patch of the day?? =



 =20 Help the patches are getting to me!!!

  I am working on = migrating a system from 8.0.5.1 to 8i (HP-UX 11.0 32Bit).
  = I have=20 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.

  8.1.6 has been patched  4 = times in 3=20 months with fairly major patches (by
  looking at the = readme's),=20 and is now being superseeded with 8.1.7.  Do I
  even = want to=20 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? =20 Any ideas?

  I'm under some time constraints to get = this tested=20 and implemented by Nov
  15th.

  Rodd Holman=20
  Enterprise Data Systems Engineer
  LodgeNet=20 Entertainment Corporation
  rodney.holman@lodgenet.com=20

  --
  Please see the official ORACLE-L FAQ:=20 http://www.orafaq.com
  --
  Author: Holman, = Rodney=20
    INET: rodney.holman@lodgenet.com =

  Fat=20 City Network Services    -- (858) 538-5051  FAX: = (858)=20 538-5051
  San Diego,=20 California        -- Public = Internet=20 access / Mailing Lists
 =20 -------------------------------------------------------------------- =
  To REMOVE yourself from this mailing list, send an E-Mail = message=20
  to: ListGuru@fatcity.com (note EXACT spelling of = 'ListGuru') and=20 in
  the message BODY, include a line containing: UNSUB = ORACLE-L=20
  (or the name of mailing list you want to be removed =