Home » Developer & Programmer » Forms » LIKE STATMENT AS PARAMETER
LIKE STATMENT AS PARAMETER [message #394586] Sat, 28 March 2009 00:09 Go to next message
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
   repid          report_object;
   v_rep          VARCHAR2 (1000);
   v_rep1         VARCHAR2 (1000);
   acyear         VARCHAR2 (15);
   alert_answer   NUMBER;
-- v_rep := fn_paperURL;
   v_rep := '/reports/rwservlet?paperrpt';

   IF (:nedcampus = 'IN COMPANY CAMPUS')
      v_rep :=
         || '&report=Employee_List_Staff_Address_Paper
             &p_address=and upper(presentaddress) like ''''%STAFF COLONY%''';
   END IF;

   web.show_document (v_rep, '_blank');

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
Messages: 20847
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.
Previous Topic: maximize window
Next Topic: Open login.fmx in a web page (SPLIT topic)
Goto Forum:

Current Time: Wed Oct 26 18:22:11 CDT 2016

Total time taken to generate the page: 0.16430 seconds