| Passing Parameter from form to report [message #88315] |
Thu, 27 June 2002 09:11  |
Godwin
Messages: 37
Registered: January 2002
|
Member |
|
|
I have this script on when-button-press trigger in forms 6.o that call the report to send the parameter to the report but when i run the report i always have to error: 'REP-0302:Parameter 'p_1' not found in report'
here is the script:
declare
plid paramlist;
the_param varchar2(15):='tmpdata';
BEGIN
plid:=GET_PARAMETER_LIST(the_param);
IF NOT id_null(plid) THEN
destroy_parameter_list(plid);
END IF;
plid := create_parameter_list(the_param);
add_parameter(plid,'P_1',TEXT_PARAMETER,:block3.paanum);
RUN_PRODUCT(REPORTS,'C:personnel_itscontractappt.rep',SYNCHRONOUS,
RUNTIME,FILESYSTEM,plid,null);
END;
Help.
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
