To save oracle report in a given location

Advertisement

Hi,
I want report to be save in d:\dbr location in pdf format .
I am running report through form.
below is the code.
declare
pl_name VARCHAR2(30) := 'tempdata';
pl_id ParamList;
varno number;
VENAME VARCHAR2(30);
VMONTH NUMBER(2);
VYEAR NUMBER(4);
vacname varchar2(100);
vitemgrp varchar2(5);
vfromdate date;
x VARCHAR2(150);
y NUMBER;
repid REPORT_OBJECT;
v_rep VARCHAR2(100);
BEGIN
repid := FIND_REPORT_OBJECT('REPORT103');
pl_id := Create_Parameter_List(pl_name);
Add_Parameter(pl_id,'background',TEXT_PARAMETER,'Yes');
Add_Parameter(pl_id,'PARAMFORM',TEXT_PARAMETER,'NO');
Add_Parameter(pl_id,'DESTYPE',TEXT_PARAMETER, 'FILE') ;
Add_Parameter(pl_id,'DESFORMAT',TEXT_PARAMETER, 'PDF') ;
Add_Parameter(pl_id,'VCOMPANY',TEXT_PARAMETER,:block50.COMPANYNAME);
Add_Parameter(pl_id,'VLYCOMPANY',TEXT_PARAMETER,:block50.COMPANYNAME);
Add_Parameter(pl_id,'FROMDATE',TEXT_PARAMETER,VFROMDATE); -- vfromdate retrived from cursor
Add_Parameter(pl_id,'TODATE',TEXT_PARAMETER,:BLOCK50.DOCDATE);
Add_Parameter(pl_id,'VACNAME',TEXT_PARAMETER,VACNAME); -- vacname retrived from cursor
Add_Parameter(pl_id,'DESNAME',TEXT_PARAMETER, 'D:\dbr\'||vACNAME||' '||:BLOCK50.DOCDATE||'.PDF') ;
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_COMM_MODE,ASYNCHRONOUS);
SET_REPORT_OBJECT_PROPERTY(repid, REPORT_EXECUTION_MODE, BATCH);
set_report_object_property(repid, report_filename,'D:\dbr\'||vACNAME||' '||:BLOCK50.DOCDATE||'.PDF' );
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_DESTYPE,FILE);
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_DESFORMAT,'PDF');
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_SERVER,'rep_adminserver_inorasrv-pc_asinst_3');
y := LENGTH ('rep_adminserver_inorasrv-pc_asinst_3') + 2;
x := RUN_REPORT_OBJECT (repid, pl_id);
WEB.SHOW_DOCUMENT('http://inorasrv-pc:7001/reports/rwservlet'||SUBSTR(x, y)||'?server=rep_adminserver_inorasrv-pc_asinst_3&userid=scott/[email protected]');
Destroy_parameter_list('tempdata');
above code gives following error
frm-93652 the runtime process has terminated abnormally.
I don't want report to be run on browser but, to be store in pdf format in a given location.
Forms & report version 11.1.2
Please help..
Edited by: parapr on Sep 21, 2012 11:43 PM

Advertisement

http://inorasrv-pc:7001/reports/rwservlet/showjobs?server=rep_adminserver_inorasrv-pc_asinst_3
I run above url
It shows status of last run jobs.
It is showing red cross in front of last run job.
I click on red cross sign. It show following error message.
The report terminated with error:
REP-110: File AKASH. cannot be opened. REP-1070: An error occurred while opening or saving a document. REP-0110: File AKASH. cannot be opened.
I run below url
http://inorasrv-pc:7001/reports/rwservlet/getserverinfo
It shows following information
Reports Server rep_adminserver_inorasrv-pc_asinst_3 Information
Server
Name rep_adminserver_inorasrv-pc_asinst_3
Version 11.1.2.0.0
Security Mode Non-secure
Running Mode In-process
Host inorasrv-PC
Process Id undefined
Start Time Sep 24, 2012 10:12:28 AM
Maximum Queue Size 1000
Other Reports Servers in the Same Cluster
Performance
Successful Jobs 704
Current Jobs 0
Future Jobs 0
Transferred Jobs 0
Failed Jobs 296
Response Time(milliseconds) 56855.7
Engine
Name Process Id Status Running Job ID Job Running Time (ms) Idle Time (seconds) Jobs Run Life Remaining (jobs) NLS Total Running Time (seconds) Total Idle Time (minutes)
rwEng-0 4500 Ready n/a n/a 300 4 46 AMERICAN_AMERICA.WE8MSWIN1252 5 5
need help..

October 11, 2015

To save oracle report in a given location

Hi, I want report to be save in d:\dbr location in pdf format . I am running report through form. below is the code. declare pl_name VARCHAR2(30) := 'tempdata'; pl_id ParamList; varno number; VENAME VARCHAR2(30); VMONTH NUMBER(2); VYEAR NUMBER(4); va

To save oracle Reports 6i in RTF format.

Hi to all.... I want t o save a report in RTF format in oracle 6i.Kindly help me to solve the issue. Scernario. After clicking the button(Ex payroll report button) in oracle forms 6i ,the Save Dialog box should be opened to save the report in RTF for

How can I use unix commands from oracle report

I have to use the following command from oracle reports. In oracle forms we can use the HOST command but what about oracle reports2.5. I have to email the attached file 100245.pdf from oracle reports to the given email id uuencode 100245.pdf 100245.p

Oracle Report Server Not Accessible

Hi Folks, I'm facing a series of issues with Oracle reports server 11g. I'l list the issues one by one. 1. I'm not able to start the weblogic server from the domain which i've created for Reports. It gives me authentication error. I've tried clearing

Oracle Report Manager & BNE

Could anybody explain me in shortly what are Oracle Report Manager (FRM) and Web Applications Desktop Integrator (BNE) used for ? Thanks, PaulOracle Report Manager is an online repository for storing and viewing reports. Report Manager provides a sec

Saving Oracle report to Database

I want to generate report on report but for that, I need to install Oracle report tables to store the report definition. Can anybody tell me where to get script to create those tables. I am using Report 6i on DBMS 8iNo, I heard that the report RDF fi

Oracle Report in PDF format

Hi, After upgrading from 11.5.7 to 11.5.10 Oracle Report in PDF format is not working(it was working fine in 11.5.7). When change output format to TEXT it working fine. Please advise? Thanks DaveHi, Perhaps it is not clear about what are the invalid

Oracle reports 6i to Oracle forms 10g migration

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

I am unable to get order by column name in oracle report parameter form

i created query like following in query builder SELECT CASE_NO, COURT_ID, CASE_TYPE, INITCAP(PLAINTIFF) PLAINTIFF,INITCAP( DEFENDENT) DEFENDENT, INITCAP(COUNSEL) COUNSEL, START_DATE, PREVIOUS_HEARING_DATE, NEXT_HEARING_DATE,INITCAP( DESCRIPTION) DESC

How to get an effective EXCEL Spreadsheet as output for Oracle report 10g

Hi All, I am a newbie in Oracle reporting. I am using 10g. I have an oracle report whose output format is PDF from the user interface. User asked for Spreadsheet output. I changed the JAVA CODE "desformat" = Spreadsheet and got the report in Exc

Discoverer 4.1.37 exporting to Oracle Reports

The documentation for installing Discoverer says to install the Oracle Reports API to export to Oracle Reports, but it is not on the Discoverer CD. Is the Reports API in another distribution, and which is the version I need with Discoverer 4.1.37? Th

Unable to start Oracle Reports Server for 10g version 10.1.2.3.0

Attention Oracle Reports Team or anyone else: I am unable to start the Oracle Reports Server for 10g version 10.1.2.3.0 of the Application Server. I have included the trace files see below. I marked the text in bold that might indicate the issues. An

Converting a simple Oracle Report to XML Publisher report template

Hello, I have a simple Oracle Report 9i which displays data from four tables. It uses three different queries to get the data. How can I simply generate a template file(say RTF) or atleast an XML source from that report? I tried joining the queries (

How to send emails from of pdf's generated by oracle reports

I have several pdf documents , I want to email those pdf's . Please let me know how to send emails from oracle reports . Thanks, PrevinI have integrated Oracle Reports with Oracle Portal and used the scheduling feature via portlets. We have reports t

Oracle Report

Hello all, I have just been given the task to find a suitable reporting tool for our application. Currently our web based application has been developed using Javascript, pl/sql packages etc with OAS and Oracle 8 database. The database will be upgrad

Oracle Reports 11.1.2 junk Arabic characters in PDF

Hi guys, When I generate a report with Arabic characters, they appear as junk characters. I did the following: Set NLS_LANG=AMERICAN_AMERICA.AR8MSWIN1256 Include C:\WINDOWS\Fonts in REPORTS_PATH (in the Registry: HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KE

HTML DB  call Oracle Report and Print

I have a PRING button on the HTML DB report. When the user click on this PRINT button it launches the oracle report location Portal Server in UNIX box. The report display in Lanscape format as I set it up. However, when I go to File/Print and click p

Controlling the HTML added by Oracle Reports

Hi, I'm having a problem with the HTML being added to the output of my report when it is run on the web. Oracle Reports seems to add all these table tags and a buch of other HTML tags that are not really needed. The tags do not affect the output of t

CAN´T OPEN OR SAVE OUTPUT REPORT

We need to view an output, but we get error message "The file is damaged and cannot be repaired". We executed customized report, it finished without errors. But when we press button "View Output" then we get error "File is damaged

Strange Problem: cannot save public report as a developer

HI all, I've testing an application in apex.oracle.com. Several days ago I started to have a strange problem with my application. I don't know what has been changed but I can't save the Interactive reports as a developer. The app doesn't display the