Re: Is this possible with "execute immediate"

In article <1145949635.345961.308770_at_u72g2000cwu.googlegroups.com>, steph says...
> as far as i know you can't pass collections as parameter of execute
> immediate. maybe you can change your procedure(s) in a way that it
> don't needs the parameter - with a package that handles these
> collections and your procedure(s) accessing this package (or being part
> of this package).
>
> stephan
>
>

I don't see how it can be done - trying to compile proc where it refers to an array variable in the using clause results in an oracle error ora- 00457 - expressions have to be of SQL types.

I am a bit stuck at the moment....

cheers

-- 

jeremy