[askdba] If anyone moving to 9.2.0.6

  • From: "Ankur Shah" <ankur_ora@xxxxxxxxxxx>
  • To: <askdba@xxxxxxxxxxxxx>
  • Date: Wed, 22 Dec 2004 09:47:35 -0500

Guys...if planing to apply 9.2.0.6 Patch for Solaris....here's the dessert
to be served along.

> Had a Tar with Oracle yesterday and thank goodness they had a quick fix
==============================================================
  Abstract

  9.2.0.6 PATCHSET ISSUE WITH FLEXIBLE PARAMETER PASSING


  Resolution History


  21-DEC-04 14:51:27 GMT

  ### Platform and O/S version, including patch set or service pack level?
###
  RDBMS:Oracle Patchset 9.2.0.6
  OS:Solaris 8.0

  ### What version and patch set level of the database are you running? ###
  9.2.0.6

  ### Are you running the most recent patch set? ###
  Yes.

  ### Problem Description and its duration: ###
  Since we applied Oracle Patchset 9.2.0.6 issue we started having issues
with
  Flexible parameter passing with one of our procedures.Below code has been
  tested to have the issue with parameters as passed on the URL below are
corrupted.

  =============================================================
  PACKAGE NDS.FLEXCHECK is
  type varr is table of varchar2(1000) index by binary_integer;
  empty varr;
  procedure checkit(name_array flexcheck.varr default flexcheck.empty,
  value_array flexcheck.varr default flexcheck.empty);
  end;
  PACKAGE BODY NDS.FLEXCHECK is
  procedure checkit(name_array flexcheck.varr default flexcheck.empty,
  value_array flexcheck.varr default flexcheck.empty) is
  gnames flexcheck.varr;
  gvalues flexcheck.varr;
  gcount number;
  begin
  gcount :=0;
  gNames := name_array;
  gValues := value_array;
  gnames(1):='ABCDEFG';
  gvalues(1):='123456';
  gnames(2):='HIJKLMN';
  gvalues(2):='789012';
  gnames(3):='OPQRSTU';
  gvalues(3):='345678';
  gcount :=3;
  for i in 1 .. gcount loop
  htp.p(gnames(i)||' - '||gvalues(i)||' - '||i||'<br>');
  end loop;
  end;
  end;

 > You can check the same at

  http://167.193.153.76/sendss_d/!flexcheck.checkit

ACTION PLAN
  =============
  Ankur,

  I have been assigned your tar. You are actually running into a known Bug #
4053924 (L/SQL PROCEDURES PRODUCE ORA-06502
  AFTER UPGRADING TO 9.2.0.6 DB). Please download this patch from Metalink
and follow t
  he readme to apply it.

  Let me know if this helps.

  Thanks.
  Bev
  @CUS

21-DEC-04 17:05:19 GMT

  ACTION PLAN
  =============
  Ankur,

  My apologies as there were two bugs filed on the same issue; however, only
Patch 4015165 (REGRN:SCALAR VARCHAR2 IN
  BINDS WITH
  DIFFERENT SIZE RANDOMLY FAILS WITH ORA-06502) contains the fix on
Metalink. Le
  t me know if you are able to find the Patch 4015165 on Metalink.

  Thanks.

  Bev
  @CUS
====================================================

> Patch 4015165 did fixed the issue and the URL should display correct data.

HTHU

Ankur Shah
Oracle DBA
DHR-GA

Other related posts:

  • » [askdba] If anyone moving to 9.2.0.6