Re: how to make function to return multiple fields??
Date: Fri, 13 May 2005 08:59:18 -0400
Message-ID: <m5edncQg9vk6ORnfRVn-uQ_at_comcast.com>
<jeffchirco_at_gmail.com> wrote in message
news:1115955692.402879.166440_at_g44g2000cwa.googlegroups.com...
> After looking into pipelined funcitons. I am not sure if this will
> work for what I want. Or maybe I just don't see and it will work.
> Basically, taking my table example at the top, in my function I want to
> pass in a number and then have a sql stament like;
> select id, fname, lname
> from employees
> where id > number_in;
>
> And then have the function just return the results of that query. Can
> someone write a little example for me. I really just don't understand
> and I have been trying to figure it out for too long. My actually sql
> statement and function is more complicated but this small example is
> the jist of what I am looking for. Thanks alot.
>
you could also return a Ref Cursor ... what's your calling environment?
++ mcs Received on Fri May 13 2005 - 14:59:18 CEST