Use cursor with stored procedure

I have a problem writing a procedure which return a cursor. Firstly, I declare my cursor in a package ...

PACKAGE p_test
as
  cursor orga is select nom_orga, adr1_orga from t_organisme;   type CurseurTest is ref cursor return orga%rowtype; end p_test;

... and then, here is the procedure which have to return the cursor :

PROCEDURE my_proc ( curseur in out p_test.CurseurTest, nom_orga out varchar2, adr1_orga out varchar2)
as
begin
  open curseur
  for
  select nom_orga, adr1_orga
  into nom_orga, adr1_orga
  from t_organisme;

end;

My package and my procedure are fine compiled. But I can't succeed to run it !
Have you any idea to run that correctly ?

TIA Best regards,
Fred Received on Mon Apr 08 2002 - 12:30:46 CEST