Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: A stored procedure / function that can pass back multiple values / a recordset
You can do it, yes, but in procedures only.
Refer to http://osi.oracle.com/~tkyte/Resultsets/index.html
Regards,
Sybrand Bakker, Oracle DBA
Hans Soelaeman <hanschan_at_home.com> wrote in message
news:1mME4.3051$k5.62992_at_news1.frmt1.sfba.home.com...
> I am using a lot of stored procedures / functions for encapsulating the
> database structure; And, I am thinking to migrate to Oracle. In PostgreSQL
I
> am able to do:
>
> create function test() returns setof text
> as 'select ''Col1:'' || col1 from atable'
> language 'sql';
>
> And calling
> select test();
>
> Will results:
> Col1: content1
> Col2: content2
> Col3: content3
>
> 3 Rows
>
> I am wondering how can I do the same in Oracle PL/SQL?
> Such calling
>
> select test() from dual;
>
> can produce multiple values / a recordset back.
>
> Thanks.
>
> Hans.
>
>
Received on Thu Mar 30 2000 - 11:56:31 CST