Re: PL/SQL "table" question...
From: Mark Everhart <nwa_at_isd.com>
Date: 1997/05/23
Message-ID: <3384ec55.0_at_news.isd.net>#1/1
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 CEST
Date: 1997/05/23
Message-ID: <3384ec55.0_at_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 CEST