ORA-01722: invalid number

[Anders Eriksson <anders.eriksson@TELE2.SE>]

Hello!

When porting SOR reports from SQLBase to Oracle
I am geting a lot of conversion problems some of
wich I understand and other that I don't.

For example I am geting:
(SQR 5528) ORACLE OEXEC error -1722 in cursor 47:
   ORA-01722: invalid number

when executing:
begin-select
sum(antalhwfel)          &fsantalhwfel
sum(drifttimmar)    &fsdrifttimmar
from felstat
     where     failurecode = $felkod and
          ( ( ar = #year and
          manad < #month ) or
          (ar = #f-year and
          manad > #month ) )
end-select

I have tested the sql-statement:
select sum(antalhwfel),
sum(drifttimmar)
from felstat
     where     failurecode = 'B' and
          ( ( ar = 98 and
          manad < 7 ) or
          (ar = 99 and
          manad > 8 ) );
in SQL*Plus and it worked fine.

What is wrong?

Regards
Anders Eriksson