Search Internet or the Oracle documentation for "ref cursor output" and you
will find many examples.
here is one.
CREATE OR REPLACE PACKAGE PKG_MUltiResultset as
TYPE MyRefCur is REF CURSOR;
procedure GetReadOnlyData(EmpCur OUT MyRefCur,
DeptCur OUT MyRefCur,
SalCur OUT MyRefCur);
END;Package body
CREATE OR REPLACE PACKAGE BODY PKG_MUltiResultset as
PROCEDURE GetReadOnlyData(EmpCur OUT MyRefCur,
DeptCur OUT MyRefCur,
SalCur OUT MyRefCur)
IS
BEGIN
open EmpCur for select * from emp;
open DeptCur for select * from dept;
open SalCur for select * from salgrade;
END;
END;"Philippe Makowski" <makowski_at_XXXa6cmo.fr> wrote in message
news:Usenet.amlifhnc_at_localhost...
> I have a query like this :
> SELECT * FROM ETABLISSEMENT
> WHERE NUM_ETAB IN(
> SELECT NUM_ETAB FROM
> (SELECT
> SUM(DECODE(ID_ANNEE,1998,BB)) AS N ,
> SUM(DECODE(ID_ANNEE,1999,BB)) AS N1 ,
> NUM_ETAB
> FROM DONNEES_TP
> WHERE ID_ANNEE=1998 OR ID_ANNEE=1999
> GROUP BY NUM_ETAB)
> WHERE
> ((N IS NOT NULL AND N1 IS NULL)
> OR ((N1-N)/N)<0.5))
>
> But I would like not to hard code 1998,1999 and 0.5 but send them as
params
> How can I do ?
>
Received on Mon Mar 24 2003 - 14:10:52 CST