Home » Developer & Programmer » Reports & Discoverer » Integration Error ..invalid parameter list in oracle report 10g
Integration Error ..invalid parameter list in oracle report 10g [message #631753] Mon, 19 January 2015 08:30 Go to next message
irfankundi786@yahoo.com
Messages: 269
Registered: February 2009
Location: pakistan
Senior Member

i have the two report to called from oracle form 10 g but one report run but other return the title error the code is...
declare
pl_id paramlist;
begin
pl_id = get_parameter_list(pl_rep);
if not id_null(pl_id) then
destroy_parameter_list(pl_id);
if is_gst then
pl_id := create_parameter-list(pl_rep);
set_report_object_property('rpt_obj',report_name,'/purchase/a.jsp');
add_parameter(pl_id,'p_1',text-parameter,:block.code);
add_parameter(pl_id,'p_2,text-parameter,',34);
Run_report('rpt_obj',pl_id);
Else
pl_id := create_parameter-list(pl_rep);
set_report_object_property('rpt_obj',report_name,'/purchase/b.jsp');
add_parameter(pl_id,'p_1',text-parameter,:block.code);
add_parameter(pl_id,'p_2,text-parameter,',90);
Run_report('rpt_obj',pl_id);
End if;

Re: Integration Error ..invalid parameter list in oracle report 10g [message #631769 is a reply to message #631753] Mon, 19 January 2015 10:43 Go to previous message
Littlefoot
Messages: 21572
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
This code is FULL of syntax errors - fix them first.

If there are two reports and one of them works, why don't you reuse that code (and modify what's necessary)?

Being a member for 5 years, you could have learnt how to use CODE tags in order to preserve code formatting. You do format your code, don't you?
Previous Topic: getting different laguage output in reports
Next Topic: Error while converting Reports from rdf to rep
Goto Forum:
  


Current Time: Sat Jul 04 11:29:55 CDT 2020