"Jack" <never_at_inamillion1.com> wrote in message
news:Xns93A79789766D9neverinamillioncom_at_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!
The key is to do the packaged procedure in the database, and then call it
from the ASP page.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
Received on Fri Jun 27 2003 - 09:25:41 CDT