Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> How to return a recorset created dinamically?

How to return a recorset created dinamically?

From: Nobody <nobody_at_anyone.com>
Date: Fri, 1 Dec 2000 14:08:46 +0100
Message-ID: <9087bq$imp$1@talia.mad.ttd.net>

Hi everyone:

    I want to build a procedure.
    It must return a cursor in PL/SQL like this structure:

Select a.1 as &var1,

            a.2 as &var2
from table a

   where a.3 = &var3;

    Var1, var 2 and var3 are procedure parameters or variables.

Does anybody know a way to do this?
Sorry for my poor english.
Thanks and please mail me to paloma_at_tice.es Received on Fri Dec 01 2000 - 07:08:46 CST

Original text of this message

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