Hi again!
I tryed as u told me but i still gave some difficulties.. ^^
So i thought to post the code of my stored procedure... and the error
oracle gives to me :P

First i created the package:

CREATE OR REPLACE PACKAGE "SPASQUA"."riferimenti" is type curref is
ref
cursor;
end riferimenti;

and the corrisponding package body:

CREATE OR REPLACE PACKAGE BODY "SPASQUA"."riferimenti" is type
curref is
ref cursor;
end riferimenti;

then the procedure:


CREATE OR REPLACE PROCEDURE "SPASQUA"."RESULTS" (oggetto in
varchar2,
rife out riferimenti.curref)
as
cursor result is
select oggetto
from allarmi
where oggetto between 10 and 15;
reftype result%rowtype;
begin
open result;
fetch result into reftype;
close result;
open rife for
select * from session_context;
end returnresults;

I really hope u can help me out ^_^;;
10x!