failed to parse SQL query by one user
cc13Aug 5 2009 — edited Aug 6 2009Hi all,
in my app i have a text-item with a submit button. In this item i type a name and a report after the item-region show me the result(s). this works for all my users (>2000) perfectly, but one of this users become an error in the report-region:
failed to parse SQL query:
ORA-01403: no data found
We try this with the same searchstring on the same computer/browser. If i logged in the result is ok, if the user logged in, the error message shows. If i try this on the computer from the user with me logged in, result ok. If the user try this on an other pc, results error.
I have an productive and a developer workspace. In the developer workspace the user can try this perfectly without errors. Only in the productive workspace the error shows.
The SQL-Select in the reprirt ist verry simple:
select id
, name
, raum
from table
where instr(upper(name), upper(:P60_SEARCH))>0
However all users can use this search-field with report perfectly, only this one user has the error. It is no restrictions on this item or report.
Can anybody help me?