| Integration Error ..invalid parameter list in oracle report 10g [message #631753] |
Mon, 19 January 2015 08:30  |
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  |
 |
Littlefoot
Messages: 21823
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?
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
