Re: variable number of pl/sql bind variable ?

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Thu, 2 Dec 1999 16:33:27 -0000
Message-ID: <944152526.12690.0.nnrp-10.9e984b29@news.demon.co.uk>

There is an item on my web site about
passing an IN list as a single variable using a CAST() of an object type.
This may help.

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

tedchyn_at_yahoo.com wrote in message <8265le$egs$1_at_nnrp1.deja.com>...
>Sir:
>
>I have a plsql block with
> select xx from tab_a where xx in(:v1,:v2 and etc)
>
>the max number of bind variables can be 0 to 1000.
>
>One of possible solution is to use a function -
>where xx in(select * from a <function>). I am looking
>for an example of this sort.
>
>Thanks in advance
>Ted
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
Received on Thu Dec 02 1999 - 10:33:27 CST