PL/SQL procedure and input array parameter

From: Matt Houseman <mhousema_at_ix.netcom.com>
Date: Wed, 29 Dec 1999 18:30:47 -0800
Message-ID: <84eg03$91c$1_at_nntp4.atl.mindspring.net>



All,

[Quoted] Is there an easy way to bind an input array into the where clause of a SQL statement?

For example:

TYPE g_foo_array IS TABLE OF foo.foo_id%TYPE INDEX BY BINARY_INTEGER;

PROCEDURE foo ( foo_array IN g_foo_array ) IS

    CURSOR cur_find_fnd_acct_per IS

        select bar from foo where foo_id IN foo_array;

BEGIN
    ...
END; Thanks in advance,
Matt Houseman Received on Thu Dec 30 1999 - 03:30:47 CET

Original text of this message