LIKE STATMENT AS PARAMETER [message #394586] |
Sat, 28 March 2009 00:09 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
ambreensh
Messages: 20 Registered: December 2007 Location: Karachi
|
Junior Member |
|
|
i create a report which give address of employee living in company staff colony or outside company staff colony .
i pass parmeter from form which is as follow
DECLARE
repid report_object;
v_rep VARCHAR2 (1000);
v_rep1 VARCHAR2 (1000);
acyear VARCHAR2 (15);
alert_answer NUMBER;
BEGIN
-- v_rep := fn_paperURL;
v_rep := '/reports/rwservlet?paperrpt';
IF (:nedcampus = 'IN COMPANY CAMPUS')
THEN
v_rep :=
v_rep
|| '&report=Employee_List_Staff_Address_Paper
&p_address=and upper(presentaddress) like ''''%STAFF COLONY%''';
END IF;
web.show_document (v_rep, '_blank');
END;
but when i access report it give following error
REP-52006: Failed to decode the specified URL and%20upper(presentaddress)%20like%20''%STAFF%20COLONY%'.
[EDITED by LF: removed superfluous empty lines, formatted code and added [code] tags]
[Updated on: Sat, 28 March 2009 16:04] by Moderator Report message to a moderator
|
|
|
Re: LIKE STATMENT AS PARAMETER [message #394626 is a reply to message #394586] |
Sat, 28 March 2009 16:06 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21823 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
Perhaps you should pass an "ordinary" parameter (from form to a report) and create the WHERE condition in the report by using a lexical parameter.
|
|
|