Strange Report behaviour --- Report error ORA-00936 missing expression (after 8th position (A8) of u

Anuradha_Deo_(PATCOM01User2_(Delete)_2735478)

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.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 above query.Attachment is the screen cam related to the problem.Please suggest a solution for this problem. Thanks

Martin_Gäckler

Hi,First: I did not find a diference between your third and forth subquery, so you can omit the forth subquery to reduce the number of bind variable.Second: You can use more than two user input fields to search for your values, so that you do not need to break your user's input into several parts using instr and substr:... where valstr in (%2,%3,%4) ...Third: You should search the value of the database field whithin the userinput:... where instr( valstr, %2 ) > 0 ...Hope this helpsMartin