Calling Report from Form Error ORA-06508

Advertisement

Dear all,
I want migrate from Fom6i to Oracle Developer Suite 10g (10.1).
Folder Form = C:\APLIORA\IRS\FORM
Folder Report = C:\APLIORA\IRS\REPORT
I have modified file DEFAULT.ENV
FORMS_PATH=C:\APLIORA\IRS\FORM;C:\APLIORA\IRS\REPORT
i do not have problem call a form from form.
but when i call report from form show error ORA-06508 : PL/SQL : could not find program unit being called ; -6508
my procedure is
PROCEDURE Call_Report IS
     list_id ParamList;
BEGIN
list_id := Get_Parameter_List('input_params');
IF NOT Id_Null(list_id) THEN
Destroy_Parameter_List(list_id);
END IF;
list_id := Create_Parameter_List('input_params');
Add_Parameter(list_id,'MAXIMIZE',TEXT_PARAMETER,'YES');
Add_Parameter(list_id,'ORACLE_SHUTDOWN',TEXT_PARAMETER,'YES');
RP2RRO.RP2RRO_RUN_PRODUCT(REPORTS,'TESTREPORT.REP',SYNCHRONOUS,RUNTIME,FILESYSTEM,list_id,null);
END ;
Do I miss something ?
Can any one help ?
Thanks

Advertisement

Hi,
Thank you for your replay.
The problem have solved.
This my step :
1. Install Windows XP SP2 and Form 10.1.2.0.2 on new pc.
2. Install Jinit version 1.3.1.28.
3. Create report server
3. Compile form, report and pll
4. call report from from with this procedure :
PROCEDURE Call_Report (vFILENAME varchar2) IS
report_id                Report_Object;
ReportServerJob VARCHAR2(100);
vc_rep_status      VARCHAR2(100);
repsvr                          varchar2(21) := 'myserv';
userid                         VARCHAR2(100);
pass                          VARCHAR2(100);
Host                    VARCHAR2(100);
BEGIN
userid          := Get_Application_Property(USERNAME) ;
pass          := Get_Application_Property(PASSWORD) ;
Host          := Get_Application_Property(CONNECT_STRING) ;
report_id:= find_report_object('REPORT');
SET_REPORT_OBJECT_PROPERTY(report_id,REPORT_FILENAME,vFILENAME||'.jsp');
SET_REPORT_OBJECT_PROPERTY(report_id,REPORT_COMM_MODE,SYNCHRONOUS);
SET_REPORT_OBJECT_PROPERTY(report_id,REPORT_SERVER,repsvr);
ReportServerJob:=run_report_object(report_id);
vc_rep_status := REPORT_OBJECT_STATUS(ReportServerJob);
WHILE vc_rep_status in ('RUNNING','OPENING_REPORT','ENQUEUED', null)
LOOP
vc_rep_status:=REPORT_OBJECT_STATUS(ReportServerJob);
END LOOP;
IF vc_rep_status='FINISHED' THEN
WEB.SHOW_DOCUMENT('/reports/rwservlet?report='||vFILENAME||'.jsp'||'&userid='||userid||'/'||pass||'@'||Host||'&destype=CACHE&desformat=PDF&paramform=yes','_blank');
ELSE
message ('Report failed with error message '|| vc_rep_status);
END IF;
END;
Ok, but i have another strange error. I will post new thread.
Thank you and regards
Teguh S

October 11, 2015

Calling Report from Form Error ORA-06508

Dear all, I want migrate from Fom6i to Oracle Developer Suite 10g (10.1). Folder Form = C:\APLIORA\IRS\FORM Folder Report = C:\APLIORA\IRS\REPORT I have modified file DEFAULT.ENV FORMS_PATH=C:\APLIORA\IRS\FORM;C:\APLIORA\IRS\REPORT i do not have prob

REP 110 & REP 0110 .calling reports from Form 10g(10.1.2.0.2)

Hi All, We are migrating form from Oracle form 6i to Oracle 10g(10.1.2.0.2). I am calling reports from forms using Web.Show_Docment(). When we run reports in report builder 10g it works fine. But when we try to run reports from Forms 10g it throws er

Calling report from form. Need PDF output

I am calling a report from a form using RUN_PRODUCT. I need to display the form in PDF format. When the user clicks the button in the form to run the report, acrobat reader should open up and the report displayed there. Please help. ThanksThanks for

Calling reports from forms...i have 10 days left to find a solution please!

here is the scenario i connect to a oracle 9i server from home. i use winxp and 9i Developer to create database applications. when i need to run forms i have to start an OCJ4 Instance, i have a problem though.... i need to run a report from a form an

Parameter form display while calling reports from form

Dear All, I am running reports from form using run_report_object. I do not want to see parameter form while running the report. How do I do that. Thanks in Advance Gaurav ShahHi, try to set paramform=NO in your parameter list DanielRead other 2 answe

Plz help in calling reports from Form in browser

Hi! I am using 9iAS(1.0.2.2.1) + 8.1.7 database on the same machine with Win NT4.When i invoke report from my system's main form(oracle form6i) using parameter list as Run_Product(reports,'..\iReports\glrxx13.rep',synchronous,RUNTIME,FILESYSTEM,pl_id

Supressing the parameter form when calling report from form...

Hi everybody I call a report from a form passing a parameter. After pressing the button, the runtime parameter from appears. How do I suppress it so that the report appears right after pressing the button??? Thanks SergueiHi Serguei , You have to add

HOW TO Call REPORT from FORM usning a Button ?

Hi All, Please Help me and Help other Beginers in this : Hot to call a report from a form using WHEN_BUTTON_PRESSED trigger (using Oracle 10g R1) Should i save the report as .rdf or .jsp ? Should i save the report in a specific path ? Should i add th

Run_Report_Object -- Calling report from Form

Hello: Where can I find a technical notes on VALID combination of system parameters in calling report using run_report_object from FORMS in 10G? Not sure what are valid values and combinations. Do we HAVE to pass a REPORT SERVER along with run_report

FRM-41214 while calling Report from Forms DS9i

Hi ! I am getting FRM-41214 'Unable to run Report' when i run a report using Run_report_object in Developer Suite 9i. I have checked the Report server which is up and running. Any suggestion for troubleshooting. Take care ImranThis is Note:260451.1,

Using the Query Partitioning Technique for calling reports from forms.

Hello everyone, I am having problems using the Query partitioning technique which does not work (??) on the web environment. It seems like you are currently using it. However, I'm not sure whether you have tried this on the web environment. Anyway, s

URGENT: Calling Reports from Forms (10g)

Hi, I've tried to understand a pdf file on this subject, but I still can't do what I want. I need to create a button on a form that, When pressed, calls a report. Could someone help me showing some code?? Thanks!!Tiago, there's a good Whitepaper at h

How to hide URL when calling Reports from Forms 10g.

Hi , When end user runs a report through a form then report output is displayed and following type of URL is also generated on address bar of browser: http://server:7778/reports/rwservlet/getjobid22243?server=rep_servername_appsrv Can we hide this UR

Error : ORA-06508: PL/SQL: could not find program unit being called

Hi I got surprise issue while testing my Oracle code . Let me explain first the environment detail . Our appliaction built on Java/J2EE(Weblogic) and backend is Oracle 11g re2 . While calling from java it call thru different user which have been prov

Issue calling report from a Form(11.1.2).

Hi, I have an existing code in the form to call a report and it seems to be working in the current 10g version of production server and I am migrating forms 10g to 11gR2. My issue here is when, I want to call the report from Forms 11g ( i.e. in devel

Calling Report From Oracle Forms

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

Call report from form10g.

Hi all, i has one form and i want to call report name 'DOCK_RECEIPT' from Form. I create one button name ' CALL_REPORT', and want to when click into this button, form call report above. But i don't know configure Form and Report, and code for button

Call report under form 10g

how I call report under form 10g from Push Button trigger without haveing Oracle Application Server ? is there any way to do so ? ThanksYou use the run_report_object. See the help file for information on how to use it. By the way, you must use the Ap

How to run report from forms

hi all, i have tried to run report from forms using below codig(got from online help) DECLARE      repid REPORT_OBJECT;      v_rep VARCHAR2(100);      rep_status varchar2(20);      v_host varchar2(100):= 'localhost'; v_port varchar2(10); v_parameter_

Hide UserID, Password, and Report Path when call Report from Report

Hi, I have been able to call Report from Report using the hyperlink. I put these code in my Field on the Report caller. function F_3FormatTrigger return boolean is   temp varchar2(2000); begin   temp := 'http://<computer_name>:8889/reports/rwservlet