| passing parameter list to report 9i [message #186446] |
Tue, 08 August 2006 00:31  |
engr_anzar
Messages: 2
Registered: August 2006
Location: KARACHI
|
Junior Member |
|
|
hi 2 all
i m new new user
i wanna create parameter list on form and passing this parameter to 9i report ,if i m using this query ...
PROCEDURE run_report(where_clause VARCHAR2(50), person_id NUMBER) is
v_pl_id PARAMETERLIST;
v_pl_name VARCHAR2(10) := 'my_list';
v_rep_id REPORT_OBJECT;
v_rep_tx VARCHAR2(100);
BEGIN
-- delete paramter list if it currently exists
v_pl_id := get_parameter_list(v_pl_name);
IF NOT id_null(v_pl_id) THEN
v_pl_id :- destroy_parameter_list(v_pl_id);
END IF;
-- create parameter list
v_pl_id := create_parameter_list(v_pl_name);
-- add parameters
add_parameter(v_pl_id, 'where_clause', TEXT_PARAMETER, 'where person_id=' person_id);
-- run report
v_rep_id := find_report_object('my_report');
v_rep_tx := run_report_object(v_rep_id, v_pl_id);
END; /* End of Procedure */
END; /* End of package body */
/
-------
so this query shows error and how can i display rep on web (pdf format) for this now i user this query.
WEB.SHOW_DOCUMENT('http://132.147.100.100:8888/reports/rwservlet?
destype=cache&desformat=HTML&report=call_me2.rdf&userid
=scott/tiger@orav817&dno='||:text_no);
so plz solve my problems ( how can i add parameter list )
thanks in advance
regards,
Anzar Baig
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
