没有合适的资源?快使用搜索试试~ 我知道了~
Oracle Application Server 10g Form 调用报表文档
5星 · 超过95%的资源 需积分: 9 36 下载量 45 浏览量
2008-10-31
13:26:54
上传
评论
收藏 170KB PDF 举报
温馨提示
试读
18页
Oracle Form 10g 用 Run_report_object 调用报表
资源推荐
资源详情
资源评论
Oracle Forms Services – Using
Run_Report_Object() to call
Reports with a parameter form
$Q2UDFOH7HFKQLFDO:KLWHSDSHU
)HEUXDU\
! #"$% &%'()*+
Oracle Forms Services – Using Run_Report_Object()
To Call Reports with a Parameter Form
Introduction........................................................................................................3
Problem description..........................................................................................3
Solving the problem with ‘pfaction’................................................................3
USING PL/ SQL functions to encode URL parameters.............................4
Building a generic procedure to call Reports.................................................6
Advanced Reports Security............................................................................11
Using the oracle.reports.utility.FrmReportsInteg Bean in Forms........11
Forms Services Configuration...................................................................13
Formsweb.cfg file...................................................................................13
forms90/ java directory..........................................................................14
basejini.htm..............................................................................................14
Summary...........................................................................................................14
Appendix A: FrmReportsInteg Bean functionality.....................................15
SET_<nn>ENCRYPTION_KEY..........................................................15
Example for Oracle9L Reports..............................................................15
Example for Oracle10J Reports...........................................................15
SET_MAX_AGE .......................................................................................15
SET_COOKIE_DOMAIN ......................................................................15
SET_COOKIE_PATH .............................................................................16
WRITE_LOGOUTPUT...........................................................................16
Enabling debug messages example......................................................16
Disabling debug messages example.....................................................16
WRITE_USERID_COOKIE ..................................................................16
Appendix C: Known Issues ...........................................................................17
JInitiator version dependency....................................................................17
! #"$% &%'()*,
Oracle Forms Services – Using Run_Report_Object()
to call Reports with a parameter form
,1752'8&7,21
This document explains how to call Reports that have a parameter form from
Forms Services using the Forms RUN_REPORT_OBJECT Built-in.
The solution described in this document works with the Forms and Reports
components of Oracle Application Server releases 9.0.2.x and 10J.
All PL/ SQL and Java code shown or mentioned in this document can be
downloaded from http:/ / otn.oracle.com/ products/ forms/ .
352%/(0'(6&5,37,21
Using the Forms RUN_REPORT_OBJECT() Built-in to call Oracle Reports that
contain a parameter form requires code changes in Forms to run on the Web.
The reason for Reports parameter forms not working, when called from Forms
using the RUN_ REPORT_OBJECT Built-in, is an empty action attribute in the
generated Reports HTML parameter form. Because RUN_REPORT_OBJECT()
calls Reports directly on the server, Reports cannot access the Web environment
to obtain the information required to populate the action attribute when generating
the HTML parameter form.
The <ACTION> attribute is part of the standard HTML <FORM> tag that
defines what to do when a user presses the submit button. The <ACTION>
attribute in the Reports parameter form should contain hidden runtime parameters
that are required to process the Reports request after the user presses the submit
button.
This paper presents a Reports command line parameter that helps solve this
problem with minimal coding.
62/9,1*7+(352%/(0:,7+µ3)$&7,21¶
“pfaction” is a command line parameter in Oracle Reports that can be used to add
the hidden runtime parameter to a Reports parameter form when calling Reports
from Forms, using the RUN_REPORT_OBJECT() Built-in.
The syntax for the value “pfaction” parameter looks like this:
To learn about using Oracle Forms’
RUN_REPORT_OBJECT Built-
in to
call Oracle Reports from Forms, see
the Whitepaper “Integrating Oracle9iAS
Reports S
ervices in Oracle9iAS Forms
Services” .
! #"$% &%'()*.-
UHTXHVW85/BWRBUZVHUYOHW!"BKLGGHQBHQFRGHGBRULJLQDOBXUOBTXHU\BVWULQJ!
The “request URL_to_rwservlet” contains the protocol, the host name, the port,
the Reports Web context path and the Reports Servlet name.
For example:
KWWSIQLPSKLXSFXVRUDFOHFRPUHSRUWVUZVHUYOHW
The “encoded_original_url_query_string” is a duplicate of all Reports system and
application parameters passed from Forms to Reports using the SET_REPORT_
OBJECT_PROPERTY Built-in, encoded in a URL.
For example, the Reports command line parameters
GHVW\SH FDFKHGHVIRUPDW KWPOFVVXVHULG VFRWWWLJHU#RUFO
would be added as a value to the “pfaction” parameter as
GHVW\SH FDFKHGHVIRUPDW KWPOFVVXVHULG VFRWW)WLJHURUFO
In order to call a Report that contains a parameter form from Oracle Forms using
RUN_REPORT_OBJECT(),do the following:
1. Provide the protocol, the host name of the server, and the server port;
2. Provide the Reports virtual path and the name of the Reports Servlet;
3. URL encode the parameter value of the “pfaction” command parameter.
The following Forms Built-in will be used to pass the “pfaction” command from
OracleForms Services to Reports:
6(7B5(3257B2%-(&7B3523(57<KGO5(3257B27+(5·SIDFWLRQ«·
Note that if you are using the REPORT_OTHER Built-in to pass application
parameters to Reports, the application parameters must also be contained in the
pfaction parameter.
86,1*3/64/)81&7,21672(1&2'(85/3$5$0(7(56
Because the “pfaction” parameter is added as ACTION parameters to the Reports
HTML parameter form, it is important to make sure that no character is contained
that could cause problems. One example that may cause a problem when
embedded in a URL is a blank character. Therefore, most developers URL-encode
blanks as ‘%20’. The PL/ SQL function “ENCODE”, as listed below, is an
example routine that encodes the following characters: “;”,“/ ”,”?”,”:”,”@”,”+”,
”$”,”,” and “ “ (semicolon, forward slash, question mark, colon, at, plus sign, dollar
sign, comma, and blank space).
剩余17页未读,继续阅读
资源评论
- qing999ff2013-11-11資源不錯,很有用
- cenjiaming2013-03-25资料还是满好的,只是是英文的。
cfj_108
- 粉丝: 0
- 资源: 3
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功