Problems with CharArrayType after upgrade from 7.3.4 to 8.1.7.1

From: <Cherie_Machler_at_gelco.com>
Date: Wed, 30 May 2001 10:42:19 -0700
Message-ID: <F001.00313CF4.20010530094048@fatcity.com>

After upgrading from Enterprise Edition 7.3.4 to 8.1.7.1 on Sun Solaris 2.6, we are
having problems executing a procedure with CharArrayType as shown below. We don't get any error message. The package simply does not return any rows when there are rows out there that should be returned.

The developer is trying to turn on some debug but I thought I would also ask if anyone sees anything that is a no-no now under 8.1.7.1. Is there something that I need to do in order to migrate this code that wasn't done automatically?

CREATE OR REPLACE PACKAGE CCFILECD AS TYPE NumArrayType IS TABLE OF NUMBER

     INDEX BY BINARY_INTEGER; TYPE CharArrayType IS TABLE OF VARCHAR(31)

     INDEX BY BINARY_INTEGER; PROCEDURE GETFILECODES(file_code OUT CharArrayType,

               file_prefix    OUT CharArrayType,
               start_pos      OUT NumArrayType,
               length         OUT NumArrayType,
               num_lines_to_skip OUT NumArrayType,
               record_length  OUT NumArrayType,
               cntry_cd_proc  OUT NumArrayType,
               curr_cd_proc   OUT NumArrayType,
               count          OUT NUMBER);

END CCFILECD; Thanks for any advice you can give,

Cherie Machler
Oracle DBA
Gelco Information Network

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author:
  INET: Cherie_Machler_at_gelco.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Wed May 30 2001 - 12:42:19 CDT