Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

failed to parse SQL query by one user

cc13Aug 5 2009 — edited Aug 6 2009
Hi 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?
This post has been answered by Denes Kubicek on Aug 6 2009
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 3 2009
Added on Aug 5 2009
12 comments
836 views