Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: oo4o binding values to "in" clause

Re: oo4o binding values to "in" clause

From: Jack <never_at_inamillion1.com>
Date: Fri, 27 Jun 2003 13:53:45 +0000 (UTC)
Message-ID: <Xns93A79789766D9neverinamillioncom@127.0.0.1>


"Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in news:3efb09aa$0$10627$ed9e5944_at_reading.news.pipex.net:

> You are sort of on the right lines. You need to create a user defined
> type which is an array of varchars - this will be your inlist
> then you can parse your string into members of this array and finally
> you can use the new table functions as of 8i (I think) in the sql
> statement. The PL/SQL below works for me. I have only returned out
> parameters in this instance. I believe that the oo40 documentation has
> examples of how to return parameters to vb/asp.

Ah well, far too overkill for what I want - and trying to do that in ASP would be ... unworthwhile :)

Thanks for the answer! Received on Fri Jun 27 2003 - 08:53:45 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US