Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: oo4o binding values to "in" clause
"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
![]() |
![]() |