Re: Returning many values in a PL/SQL function

From: Maxim Krapivin <baltros_at_mail.wplus.net>
Date: Wed, 5 Aug 1998 19:45:27 +0400
Message-ID: <35c87f1c.0@baltrosg2>

You can use Oracle PL/SQL Tables.
Create a package specification for type definitions, for example:

PACKAGE my_arrays IS

TYPE StringAray IS TABLE OF String(255) INDEX BY BINARY_INTEGER;

. . . . END my_arrays;

and use parameters of this types in your functions:

    FUNCTION MyFunc (param1 in out my_arrays.StringArray) RETURN Integer IS     BEGIN
        ...
    END MyFunc;

Best Regards. Maxim.

Ulf.pettersson_at_ims.se wrote:
>Hi,
>
>is there a way to return multiple data from a stored procedure ? (with the
>object option in version 8 it works from other PL/SQL procedures) but how
do I
>do if I want to read a set of strings from a VB program ? workarounds ?
Received on Wed Aug 05 1998 - 10:45:27 CDT