How to call Reports in oracle forms 10g
How to call Reports in oracle forms 10g.
I am using Oracle Forms 10g Reports 10g and Database 10 and and Operating system Windows XP.
Please give me the Solution.
Thanks and Regards,
October 11, 2015
View Thread Other 7 Replies on community.oracle.com
Please check the following code.
plid := Get_parameter_List('tmp');
IF NOT Id_Null(plid) THEN
Destroy_parameter_List( plid );
plid := Create_parameter_List('tmp');
Add_parameter(plid, 'PARAMFORM', TEXT_parameter, 'NO');
repid := FIND_REPORT_OBJECT('POL_REP');
v_rep := RUN_REPORT_OBJECT(repid,plid);
rep_status := REPORT_OBJECT_STATUS(v_rep);
WHILE rep_status in ('RUNNING','OPENING_REPORT','ENQUEUED')
rep_status := report_object_status(v_rep);
I am used to Start the Report sever 'Rwserver Server=prod_Report_Server Start'
OracleAS Report Services
Version :- 10.1.2.0.2
Name :- prod_report_server
Status :- Server is Shutting down
Jobs in Queue 0
Active Engines 0
I got the Following Error when I trying to run the Report
FRM-41211: Integration error:SSL failure running another product
Thanks and Regards,
Dear All, How to call Reports in oracle forms 10g. I am using Oracle Forms 10g Reports 10g and Database 10 and and Operating system Windows XP. Please give me the Solution. Thanks and Regards, FaziludeenHi Omkar, Please check the following code. DECL
Problem displaying a report from within Oracle 10g forms. After a lot of work, we are able to access and actually display a report directly from Internet explorer and view the report from the report server as well. The successful url was: http://york
Hi everyone, I am trying to call a crystal report from Oracle Forms 10G. I have a button on my Form which when clicked calls a Crystal Report which the uaser then wants to save as a PDf file. Can someone please send me the code to do this and also th
Hi I am calling this one report from oracle forms, I am using global temporary table to run that report. I am first inserting data into the temporary table through oracle form and then i am calling report in that form to view the data in that tempora
Hi, Hi, Env: 22.214.171.124.2 (forms 6i/reports 6i) Database: Oracle 10g r2 We are running a client server environment and not web based. I want to run the forms 6i or reports 6i directly from a database procedure/function and not by creating a procedure i
how sending a character mode report from Oracle 10g report to a printer. I'm sending to a printer located in the network i have theses parameter report desformat = prtname desname=?????? destype= ????? mode=character i would like to preview the repor
How to fetch a column in oracle form by using DB prcedure's refcursor. There was not isseu to create and call the procedure in oracle forms but when I was trying to fetch a particular column and assing the value to text box, I got an error invalid re
Hi, I have a problem during calling a report object 10g from a FORM, the source code is below the message, an the error message is can't not find PLAN_FUZZY (my report module name)...... WHY ??? DECLARE repid REPORT_OBJECT; v_rep VARCHAR2(1
Hi I am using forms 10g There is a java class email_class (to send emails and attachments). this java class (email_class) has further used two moere .jar files (activation.jar & mail.jar). Now I want to use this java class (email_class) in my form to
Hi, I have .rdf files which were created on Oracle Reports 6i. I would like to migrate the .rdf files into Oracle Reports module which is present as a part of Oracle Forms 10g to generate PDF output. Please let me know the detailed steps to be follow
Could you provide me step by step a solution on how I can call crystal reports 11 from oracle forms 10g application.Hi, Use web.show_document for calling the reports. Check out forms online help for syntax and example of web.show_document. -ArunRead
How to invoke crystal reports from Oracle forms 11g R2 along with passing parameter to it. how to pass parameters to crystal report, please help.how to pass parameters to crystal report, please help.This would entirely depend on crystal reports and y
Hello, We are on Oracle EBS rel 12, Forms 10g. We have a requirement of calling a Custom Map application (Like Google Maps) from Oracle Forms 10g. When the user enters the address like town, city, country etc and clicks on a button there should be a
Hi all, I would like to call a Microsoft Word document from my Oracle Forms 10g. What would be the best way to do this? Thank you in advance.Have you tried something like WEB.SHOW_DOCUMENT('file:///<documentpath>','_blank');Read other 2 answers
Hi team, iam facing difficulty in running the Oracle Forms 10g , using IE 8.0. What are the settings i need to perform while running the forms, please help me. While Running : http://localhost:8889/forms/frmservlet the tab is not getting crashed and
Hi I have generated a web service client using jdeveloper 10g. It consists of complex type methods. I am trying to import the class files using java importer in oracle form 10g. I am able import all of them successfully except one. That one is the ma
Please if anybody can provide me with how to control the scanner thru forms 10g thru PL/SQL , Java or any other means,,, Please its urgentWell it depends - what interface does the scanner support when it connects to the machine? Is it a scanner (as i
I am going to create the graph in oracle form 10g ...i replace the java folder on the already created java folder. when i run the form i have this error. error...java.lang.unsupportedclassversion /oracle/form/fd/laf_xp_button(unsupported.major.minor.
Previously i have used DDE for uploading the data from excel to DB in oracle forms 10g.now it is throwing non-oracle exception at DDE.intiate. could you please help me to solve this issue. i use the below code APPLICATION := OLE2.CREATE_OBJ('EXCEL.AP
Hi, How to genetare reports (ssrs) with form library's data in sharepoint 2010.I am saving infopath(2010) xml form data in form library.I have 500 and more forms in the form library( more forms can come in future).How to generate reports from this xm