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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
