Re: Is this possible with "execute immediate"

In article <e2j44j$u4h$1_at_news5.zwoll1.ov.home.nl>, Frank van Bortel says...

> Something along the line of:
> declare
> g_proc varchar2(40) := 'vr.procname';
> g_name varchar2(40) := 'l_name';
> begin
> execute immediate (
> ':l_procname(p_id=>1,p_name=>:l_name'
> )
> using g_proc, g_name;
> end;
>
> ?
>

Not sure exactly waht you're getting at here Frank - doesn't that just literally pass the string value 'l_name' into the p_name param of vr.procname?

I need to find a way to pass an array param to a stored procedure using some form of dynamic SQL. Perhaps it is not possible with "execute immediate" - perhaps only with DBMS_SQL?

-- 

jeremy