Re: "in" clause using binds / oo4o / asp

"John" <Nothanks_at_noaddress.com> wrote in message news:Xns9484A02E9FCE6Nothanksnoaddresscom_at_127.0.0.1...
| "Jim Kennedy" <kennedy-downwithspammersfamily_at_attbi.net> wrote in
| news:hRNTb.215960$na.353560_at_attbi_s04:
|
| >>
| >> Perhaps I needed to state that the amount of values in the "IN" is
| > unknown.
| >> Hence I want to pass in an array, not a list of binds.
| >>
| >> Cheers
| > Look at asktom.oracle.com and search for varying elements in in list
| > Jim
|
| Hi Jim,
|
| Thanks for link, but nothing on there for asp / collections - it's all
| pl/sql blocks/functions/procedures :-(
|
| Cheers

john,

if you're constructing the SQL statement (in a string variable), then there's no issue, you just build the appropriate IN clause

but if you're passing an IN clause list in a single parameter to a stored procedure, then the ask-tom articles demonstrate how to a) use TABLE and CAST to convert the variable's content to PL/SQL structure usable in an IN subquery and b) create a reusable function to do the conversion

it's really an PL/SQL issue, not an ASP issue

see also my posts to the thread 'Input Array Processing' in c.d.o.misc

• mcs