Calling Report from Form Error ORA-06508
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
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 := Get_Parameter_List('input_params');
IF NOT Id_Null(list_id) THEN
list_id := Create_Parameter_List('input_params');
Do I miss something ?
Can any one help ?
October 11, 2015
View Thread Other 8 Replies on community.oracle.com
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 220.127.116.11.
3. Create report server
3. Compile form, report and pll
4. call report from from with this procedure :
PROCEDURE Call_Report (vFILENAME varchar2) IS
repsvr varchar2(21) := 'myserv';
userid := Get_Application_Property(USERNAME) ;
pass := Get_Application_Property(PASSWORD) ;
Host := Get_Application_Property(CONNECT_STRING) ;
vc_rep_status := REPORT_OBJECT_STATUS(ReportServerJob);
WHILE vc_rep_status in ('RUNNING','OPENING_REPORT','ENQUEUED', null)
IF vc_rep_status='FINISHED' THEN
message ('Report failed with error message '|| vc_rep_status);
Ok, but i have another strange error. I will post new thread.
Thank you and regards
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
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
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
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
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
Hi! I am using 9iAS(18.104.22.168.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
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
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
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
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,
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
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
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
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
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
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 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
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
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_
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