Returning an array from a procedure/ function

From: Simon Davies <a_person_uk_at_yahoo.co.uk>
Date: 4 Jul 2003 08:46:48 -0700
Message-ID: <6238724c.0307040746.65536382@posting.google.com>

I'm struggling to work out how to return an array(table) from a pl/sql function/procedure. I have tried various methods using both functions and procedures.

I currently have the following code:

Package *

CREATE OR REPLACE PACKAGE MyPackage as
TYPE ARRAY IS TABLE OF VARCHAR2(250);
PROCEDURE MyProcedure(MyArray IN OUT ARRAY); END;
/

CREATE OR REPLACE PACKAGE BODY MyPackage IS   PROCEDURE MyProcedure(MyArray IN OUT ARRAY) is   BEGIN
    <snipped>
  END;
END;
/

Procedure Call * DECLARE TYPE ARRAY IS TABLE OF VARCHAR2(250); MyArray ARRAY := LOGIN_AREA('','','','','','','','','','','','','','',''); BEGIN MySchema.MyPackage.MyProcedure(MyArray); END;

***

Do excuse the poor quality of the above code. I haven't been doing this very long. All suggestion and critism greatly recieved.

Cheers Simon Received on Fri Jul 04 2003 - 10:46:48 CDT