Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

error ORA-01722: invalid number

Crystal 10. I got error ORA-01722: invalid number. I know that problem when I added {?sunitcode} parameter. The field t.sunitcode CHAR(8 BYTE) and {?sunitcode} in Crystal like string.

Need your help!

select 
    slastname, 
    sfirstname, 
          scode,
     sunitcode,
         saddr1,
         saddr2,
           scity,
         sstate,
     szipcode,
      psaddr2,
      psaddr1,
  hmyperson,
       amount
 from (SELECT  t.slastname  slastname, 
               t.sFirstName sfirstname, 
               t.scode         scode,
               t.sunitcode   sunitcode,
               t.saddr1        saddr1,
               t.saddr2        saddr2,
               t.scity            scity,
               t.sstate          sstate,
               t.szipcode     szipcode,
               p. saddr2      psaddr2,
               p. saddr1      psaddr1,
               t.hmyperson    hmyperson,
               sum(tr.stotalamount) - sum(tr.samountpaid) amount
        
FROM Tenant T, trans tr , property p
WHERE p.hmy = t.hproperty
  and t.hMyPerson = tr.hperson
  and tr.itype = 7 
  and tr.bopen = -1
  and t.hproperty = tr.hprop
  and tr.hprop = {?hprop} 
  and  t.sunitcode = {?sunitcode}


  GROUP BY t.sunitcode,
t.scode,t.sfirstname,t.slastname,t.saddr2,t.scity,t.sstate,t.szipcode, t.saddr1, p.saddr2, p.saddr1, t.hmyperson ) t
where amount>1000
ORDER BY t.scode

Former Member
Not what you were looking for? View more on this topic or Ask a question