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 -> Use returned cursor in another PL/SQL proc

Use returned cursor in another PL/SQL proc

From: roberto galbiati <roberto.galbiati_at_mgfproject.com>
Date: 5 Jan 2006 08:30:02 -0800
Message-ID: <1136478602.387464.291430@g14g2000cwa.googlegroups.com>


 hi all

i have a procedure like this (in package CORP_REPORT):

PROCEDURE Confronto
( IN_IDREQUEST IN NUMBER,
   CUR_1 IN OUT CORP_REPORT.TCUR_1
)

IS
BEGIN
  ... do something ...
  OPEN CUR_1 FOR
    SELECT * from table1, table2, tableEtc..     where <something specific> ;

END; it works perfectly with ORACLE.NET data provider, ADO, Crystal, etc...

But I need in some case to process that data again in PL/SQL, something like:

PROCEDURE NewConfronto
( IN_IDREQUEST IN NUMBER,
   CUR_1 IN OUT CORP_REPORT.TCUR_1
)

IS
  InternalTCUR CORP_REPORT.TCUR_1;
BEGIN   EXEC Confronto(IN_IDREQUEST,InternalCUR);

  OPEN CUR_1 FOR
   SELECT x,y,z
    from InternalCUR
    where <..other conditions...>;
END; How can this be done?
On the Web everyone explain how to use returned cursor OUT OF ORACLE, but not in...

Thanks
Roberto Received on Thu Jan 05 2006 - 10:30:02 CST

Original text of this message

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