Re: Use of an array NOT number cause error

On Jul 6, 2:16 pm, William Robertson <williamr2..._at_googlemail.com> wrote:

> If parameter PX is a SINARRAY then the IN clause should be
>
> IN (SELECT column_value FROM TABLE(px))
>
> and not
>
> IN (px)

I did search the docs for this too, and all I could find was

IN (SELECT column_value FROM TABLE(CAST(px as SINARRAY))

It's great to see that it works even without the CAST. Received on Fri Jul 06 2007 - 12:31:41 CDT