Re: Is this possible with "execute immediate"

From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Wed, 26 Apr 2006 10:24:43 -0400
Message-ID: <itGdnQyI2so2H9LZnZ2dnUVZ_tmdnZ2d@comcast.com>

"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).
: >
: > 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

a varray or nested table would qualify as a SQL type -- have you tried that?

++mcs Received on Wed Apr 26 2006 - 09:24:43 CDT