PL/SQL procedure and input array parameter

All,

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 Wed Dec 29 1999 - 20:30:47 CST