OraFAQ Forum: Reports & Discoverer » SRW.RUN_REPORT (REP-0091 Invalid value of parameter) help

Home » Developer & Programmer » Reports & Discoverer » SRW.RUN_REPORT (REP-0091 Invalid value of parameter) help

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

SRW.RUN_REPORT (REP-0091 Invalid value of parameter) help [message #251737]

Mon, 16 July 2007 07:23

musman
Messages: 147
Registered: July 2007
Location: Lahore

Senior Member

i have developed two reports.
1st one contains fields like company_code,maxrate,minnrate,change

then am using button on report to send company_code as parameter to another report (other report will show some data on basics
of company_code)
Button Code is
-------------------------------------
procedure U_1ButtonAction is
BEGIN
DECLARE
v_tmp char(100);
begin
srw.message(1,'Initilizaing Report');
srw.run_report('report=e:/Report/child_report
batch=yes desname=sysout desformat=dfit PARAMFORM=YES P_CODE=TO_CHAR(:company_code)' );

EXCEPTION
when srw.run_report_failure then
v_tmp := srw.geterr_run;
srw.message(1000, v_tmp);
end;
END;
-----------------------------------------
where P_CODE is parameter of 2nd report.
but when i click button on 1st report error invalid value of parameter P_CODE occurs

[Updated on: Mon, 16 July 2007 23:53]

Report message to a moderator