Já fiz de tudo e não consigo passar os parâmetros para o report estou fazendo assim:
declare
rep_id report_object;
roda_report varchar2(100);
rep_status varchar2(20);
id_job varchar2(100);
IDPARAM PARAMLIST;
begin
IDPARAM := GET_PARAMETER_LIST('RPARAM');
IF NOT ID_NULL(IDPARAM) THEN
DESTROY_PARAMETER_LIST(IDPARAM);
END IF;
IDPARAM := CREATE_PARAMETER_LIST('RPARAM');
ADD_PARAMETER(IDPARAM,'p_numero_resolucao', TEXT_PARAMETER, to_char(:RESOLUCAO.NR_RESOLUCAO));
ADD_PARAMETER(IDPARAM,'p_ano_resolucao', TEXT_PARAMETER, to_char(:RESOLUCAO.ID_ANO_RESOLUCAO));
ADD_PARAMETER(IDPARAM,'PARAMFORM',TEXT_PARAMETER,'NO');
rep_id := find_report_object('rep_resolucao');
set_report_object_property(rep_id,REPORT_COMM_MODE,SYNCHRONOUS);
set_report_object_property(rep_id,REPORT_DESTYPE,CACHE);
set_report_object_property(rep_id,REPORT_SERVER,'rep_mi4811');
set_report_object_property(rep_id,REPORT_OTHER,'IDPARAM');
roda_report := run_report_object(rep_id);
id_job := substr(roda_report,length('rep_mi4811')+2,length(roda_report));
web.show_document('/reports/rwservlet/getjobid'||id_job||'?server=rep_mi4811','_blank');
end;
Att,
Marcelo M Florindo