BELOW IS THE CODE AM USING:
Am getting the error:”There exist uncompiled objects in the report”
declare
v_rep varchar2(1000):='a';
v_rep_status varchar2(1000):='a';
v_url varchar2(1000):='';
rep_status VARCHAR2(100);
repid REPORT_OBJECT;
thelist paramlist;
begin
thelist := get_parameter_list('rep_paramlist');
if not id_null(thelist) then
destroy_parameter_list(thelist);
end if;
thelist := CREATE_PARAMETER_LIST('rep_paramlist');
ADD_PARAMETER(thelist, 'PARAMFORM',TEXT_PARAMETER,'NO');
ADD_PARAMETER(thelist, 'P_BASE',TEXT_PARAMETER,'4010');
ADD_PARAMETER(thelist, 'P_date',TEXT_PARAMETER,'01-SEP-2016');
repid := find_report_object('KAP_STMT');
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_DESTYPE,FILE);
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_DESNAME,'/orainst/orahome2/midtier/tools/web/test_area/dinesh8.PDF');
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_DESFORMAT,'PDF');
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_SERVER,'rep_orapp-uat_ASR2midtier');
v_rep:=run_report_object(repid,thelist);
rep_status := REPORT_OBJECT_STATUS(v_rep);
WHILE rep_status in ('RUNNING','OPENING_REPORT','ENQUEUED')
LOOP
rep_status := report_object_status(v_rep);
END LOOP;
IF rep_status = 'FINISHED' THEN
null;
show_message('Report Executed successfully');
ELSE
show_message('Error while running report');
END IF;
end;
your code looking good but let me ask you some questions :
1- is your report exists in the directory you provide it to your code ?
2- is your report compiled and working fine itself ?
then please share full error message and number with when this error is throwing.
thanks.