Hi!
I have this problem..
How can i pass an IN parameters into a select statement?
It continue to gimme the error: "invalid number"..

(oggetto in varchar2, oggetto2 in varchar2, rife out
riferimenti.curref)
as
begin
open rife for
select oggetto from allarmi where oggetto2 between 10 and 80;
end returnresults;

this is the code..

Is it possible that i cannot use in par for the select "in par" but
only for the WHERE condition?

10x!