Livereport error on using userinput parameters in the report query
I am working on report that accepts two inputs from the user. The second input string is a string having @ as an identifier. From the second input I am extracting required values using the oracle instr() and substr() and the position of @. On executing the report and keying parameter values, I get error of missing expression. Looking at the Query displayed on the error screen I noticed that :A9 is missing from the query. Also, the text following :A9 is not as expected. For example: In place of :A11 a number 112 is displayed. This is highlighted in the attachment.Attachemnt is the screencam of the problem.My guess is that after 8th position (:A8) of user input every thing goes wrong. The same query runs fine if I hard code the parameters in the query.Query----select dtree.*,DVersData.MimeType from DTREE,DVersData where dataid in( select distinct id from LLATTRDATA where attrid=11 and defid=9998 and valstr=%1) and (dataid in( select distinct id from LLATTRDATA where attrid=6 and defid=3840 and valstr=substr(%2,1,instr(%2,'@',1,1)-1)) or dataid in( select distinct id from LLATTRDATA where attrid=6 and defid=3840 and valstr=substr(%2,instr(%2,'@',1,1)+1,instr(%2,'@',1,2)-instr(%2,'@',1,1)-1)) or dataid in( select distinct id from LLATTRDATA where attrid=6 and defid=3840 and valstr=substr(%2,instr(%2,'@',1,1)+1,instr(%2,'@',1,2)-instr(%2,'@',1,1)-1))) and DTree.DataID=DVersData.DocID and DTree.VersionNum = DVersData.Version order by nameError ---[ORA-00936: missing expression - select dtree.*,DVersData.MimeType from DTREE,DVersData where dataid in( select distinct id from LLATTRDATA where attrid=11 and defid=9998 and valstr=:A1) and (dataid in( select distinct id from LLATTRDATA where attrid=6 and defid=3840 and valstr=substr(:A2,1,instr(:A3,'@',1,1)-1)) or dataid in( select distinct id from LLATTRDATA where attrid=6 and defid=3840 and valstr=substr(:A4,instr(:A5,'@',1,1)+1,instr(:A6,'@',1,2)-instr(:A7,'@',1,1)-1)) or dataid in( select distinct id from LLATTRDATA where attrid=6 and defid=3840 and valstr=substr(:A8,instr(,'@',1,1)+1,instr(:A10,'@',1,2)-instr(112,'@',1,1)-1))) and DTree.DataID=DVersData.DocID and DTree.VersionNum = DVersData.Version order by name] Please suggest a solution for this problem. Thanks
