Re: Is this possible with "execute immediate"

In article <itGdnQyI2so2H9LZnZ2dnUVZ_tmdnZ2d_at_comcast.com>, Mark C. Stock says...
>
> "Jeremy" <jeremy0505_at_gmail.com> wrote in message
> news:MPG.1eb988b5dc6e5f9898a196_at_news.individual.net...
> : 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).

> :
> : 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
>
> a varray or nested table would qualify as a SQL type -- have you tried that?
>

Hi Mark,

I haven't tried that - that is creating a type in the database first, yes?

I wanted to explore all avenues which didn't require me to define a type in the database (as to be honest it is because I haven't been down that path before).

cheers

-- 

jeremy