Translate

8 Aralık 2015 Salı

i-Report SQL problems:ORA-0091: invalid character

Hi I wrote some query like in iReport

" select * from tag.lms_assignment  where rownum <66000; "



and I paste it ini Jaspersoft iReport Designer to generate jrxml so I faced this error
here is the solution :

if we put ; semicolumn after query it thinks as statement like ,it thinks it is some part
of query if we delete semi column it will work

" select * from tag.lms_assignment  where rownum <66000 "




Hiç yorum yok:

Yorum Gönder

Bu Blogda Ara