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: can procedure return a recordset?

Re: can procedure return a recordset?

From: Eugene Firyago <efiryago_at_bisys.com>
Date: Mon, 8 Nov 1999 09:20:58 -0500
Message-ID: <806m9j$t5h$1@autumn.news.rcn.net>


pl/sql table or ref cursor.

<wy_at_fudan.edu> wrote in message news:803vtd$5qa$1_at_nnrp1.deja.com...
> How to write a procedure to return a recordset?
> such as P1('AA')
> = select * from t1 where f1 = 'AA';
> because I want to make a report and its data need to be calcuated.
> If the data is prepared in server and return to client one time,it
> can save a lot of time.
> and In Delphi I can use a procedure to link a report easily.
> (by the way,in Sqlserver it can easily realise.)
>
> Any Suggestings are helpful!
> Thanks in advance.
>
> YangWang.
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Mon Nov 08 1999 - 08:20:58 CST

Original text of this message

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