Dears;
I use the following code to make a search after displaying my report :
SELECT s.PROC_NAME FROM SOFT_PROC s,PROC_SERVERS p,ALIAS a WHERE a.ALIAS_SERVERNAME=:P46_SERVER and a.ALIAS_NAME=p.ALIAS_NAME and p.PROC_ID=s.PROC_ID and upper(s.proc_name ) like DECODE (:p46_search, NULL,'%', UPPER ('%' || :p46_search || '%'))
The first display is ok, and the search works sometimes well sometimes not.
I get this error :
Invalid set of rows requested, the source data of the report has been modified.
reset pagination
thx in advance for ur help