Hi again! ^_^

i'm trying to get some results from a cursor with this procedure..

(oggetto in varchar2, pagina in number, numero in number, rife out
riferimenti.curref)
as
inizio number;
fine number;
begin
inizio:= numero*pagina;
fine:= inizio+numero;
if oggetto = 'i' then
open rife for
select alarmid from imw.alarms where alarmid between inizio and fine
order by alarmid;
end if;
if oggetto = 's' then
open rife for
select alarmseverity from imw.alarms where alarmseverity between
inizio and fine
order by alarmseverity;
else
open rife for
select additionalinfo from imw.alarms where additionalinfo between
inizio and fine
order by additionalinfo;
end if;
end returnresults;

My problem is that when i exe this procedure in sql*Plus:

exec spasqua.returnresults('i', 2, 4, :looka);

i obtain this error:

SQL> print looka
ERROR:
ORA-01722: invalid number

Where's the error? :O
I'll be very glad if u can help me.. :P
10x

kin

kintaro wrote:



'i' is not a number.

Michael.