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,
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