Home » Developer & Programmer » Forms » Unable to call Oracle report from Forms (Oracle forms 10g)
icon9.gif  Unable to call Oracle report from Forms [message #655841] Wed, 14 September 2016 04:44 Go to next message
dineshkumar18
Messages: 28
Registered: September 2016
Junior Member
Below is the query am using:

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,'390898');
ADD_PARAMETER(thelist, 'P_BRANCH',text_parameter,'4010');
ADD_PARAMETER(thelist,
'P_from_dt',TEXT_PARAMETER,TO_CHAR(sysdate,'dd-mon-yyyy'));
ADD_PARAMETER(thelist, 'P_SUFFIX',text_parameter,'001'); ADD_PARAMETER(thelist, 'P_to_dt',TEXT_PARAMETER,TO_CHAR(sysdate,'dd-mon-yyyy'));
ADD_PARAMETER(thelist, 'P_USERID',TEXT_PARAMETER,'XDK');




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;


Also i have attached the reports in the oracle forms.

Am getting the below error " Reports contain uncompiled unit"
But am able to execute the report in the browser.

please assist
Re: Unable to call Oracle report from Forms [message #655843 is a reply to message #655841] Wed, 14 September 2016 05:14 Go to previous messageGo to next message
Littlefoot
Messages: 21678
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Try to recompile the report "All" (Ctrl + Shift + K).
Re: Unable to call Oracle report from Forms [message #655845 is a reply to message #655843] Wed, 14 September 2016 05:42 Go to previous messageGo to next message
dineshkumar18
Messages: 28
Registered: September 2016
Junior Member
I have done that as well.

also i was able to execute the report in the browser but not through the forms
Re: Unable to call Oracle report from Forms [message #656227 is a reply to message #655845] Wed, 28 September 2016 23:50 Go to previous messageGo to next message
dineshkumar18
Messages: 28
Registered: September 2016
Junior Member
Any update please..

Am helpless..

we contacted Oracle support too.

Still Confused dint get resolved
Re: Unable to call Oracle report from Forms [message #656406 is a reply to message #656227] Wed, 05 October 2016 05:52 Go to previous message
deepakmannazhi
Messages: 136
Registered: February 2010
Location: Dubai, UAE
Senior Member

HI are you getting this error for all reports or a for a particular report

Previous Topic: lov/err
Next Topic: Capturing incoming Phone number in Forms
Goto Forum:
  


Current Time: Fri Jun 25 05:46:52 CDT 2021