Re: PL/SQL "table" question...

From: Mark Everhart <nwa_at_isd.com>
Date: 1997/05/23
Message-ID: <3384ec55.0@news.isd.net>#1/1

In article <5m1llu$3a8_at_news.one.net>, ranga_at_shell.one.net (Ranganathan Chakravarthi) wrote:

Tables can indeed be passed as parameters to functions and procedures.

The table needs to be defined before the function or procedure is defined.

A short example.

create package example
as

        type simple is table of number index by binary integer;

        function first_number(iv_simple simple); END example;

create package body example
AS

        function first_number(iv_simple simple)
        AS
        BEGIN
                dbms_output.put_line(simple.FIRST);
        END;

END; O'Reilly has an excellent book on PL/SQL programming that I would highly recommend.
>I tried the same thing and got the same error. I came to a conclusion
>that tables cannot be passed as parameters to functions/procedures.
>I might be wrong. Let me know if you find an answer.
>TIA,
>
>-- Ranga
>-------------------------------------------------------------------------------
>-
> If it doesn't work, don't worry; if it did, you are out of a job!
>-------------------------------------------------------------------------------
>-
>Ranga Chakravarthi e-mail:
> ranga_at_one.net
>-------------------------------------------------------------------------------
>-
Received on Fri May 23 1997 - 00:00:00 CDT