Oracle Application Express 4.0(htmlDB)
参考
http://download.oracle.com/docs/cd/E17556_01/doc/install.40/e15513/otn_install.htm#BABFICIA即可
安装中的一个错误:
执行@apex_epg_config /tmp 后
SQL> @apex_epg_config /tmp
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
old 1: create directory APEX_IMAGES as '&1/apex/images'
new 1: create directory APEX_IMAGES as '/tmp/apex/images'
Directory created.
old 47: if '&IMGUPG' != '' then
new 47: if '' != '' then
old 48: l_mv_folder := '&IMGUPG';
new 48: l_mv_folder := '';
declare
*
ERROR at line 1:
ORA-22288: file or LOB operation FILEOPEN failed
No such file or directory
ORA-06512: at "SYS.XMLTYPE", line 296
ORA-06512: at line 18
Commit complete.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
timing for: Load Images
Elapsed: 00:00:08.68
Session altered.
PL/SQL procedure successfully completed.
Commit complete.
Session altered.
Directory dropped.
解决办法:
改 /tmp 为你解压apex后所在的目录,例如:/home/oracle/apex,那么/tmp为/home/oracle.
文档做了注释,但地方不对,在@apxldimg.sql是有如下说明:
引用
Tip:
The above examples assume that you unzipped Oracle Application Express in a directory called TEMP on Windows and tmp on UNIX or Linux.
附件是安装文档的拷贝。
2.变量表达法
a)应用页面上一个参数或值,首先在computation中创建一个全局变量,例如P1_RELEASE_VERSION(可以指定定义范围)
&P1_RELEASE_VERSION.
-注意后面的'.'号,用于页面引用
:P1_RELEASE_VERSION
-用于sql中
b)如果想用sql中的其它变量,用#parameters#,如:
select BUGNO,Name from bugdb;
给table的列bugNo加link,可以设置如下:
url:http://www.bug.com/bug=#BUGNO#
3.table翻页后取不到页面的变量值
如:
Table1
ID Name Age
1 a 17
ID有link,如:url:http://www.g.cn/&UID.
问题
UID是当前页面的一个参数,它是一个下拉列表。如果Table1有翻页,点击翻页后,虽然在同一页面内,但此时查看url发现&UID.没有值。
解决办法
给UID设置一computations(类似全局变量),为了保证不影selected value,设置condition,如 UID is null then UID=xx
分享到:
相关推荐
Oracle Application Express 4.0 with Ext JS
oracle-978-1-8496-8106-3 带有Ext JS的Oracle Application Express 4.0
这本书的主要目的是列出和讨论Oracle Application Express (APEX)开发团队可以使用的许多相互冲突的设计选项,然后鼓励团队制定一组针对其项目环境的最优设计决策。
oracle application express,学习apex的首要文档
Oracle Application Express Advanced Tutorials Release 3.2-310
Develop Robust Modern Web Applications with Oracle Application Express. Covers APEX 5.1. Easily create data-reliant web applications that are reliable, scalable, dynamic, responsive, and secure using...
Expert Oracle Application Express, 2nd Edition图书 示例安装代码
Develop cloud-based applications rapidly using the Oracle Application Express (APEX) platform. This book bridges the gap for readers who have experience in developing simple applications but who lack ...
Cloud Computing Using Oracle Application Express 英文epub 本资源转载自网络,如有侵权,请联系上传者或csdn删除 查看此书详细信息请在美国亚马逊官网搜索此书
如何快速安装OracleApplicationExpress,本文档有详细的安装说明,注意事项,让你快速部署OracleApplicationExpress
Oracle Application Express is a hosted declarative development environment for developing and deploying database-centric web applications. Oracle Application Express turns a single Oracle database ...
Expert Oracle Application Express, 2nd Edition is newly updated for APEX 5.0 and brings deep insight from some of the best APEX practitioners in the field today. You'll learn about important features ...
Oracle Application Express 5.1 Basics & Beyond
精通Oracle电子书_Pro Oracle Application Express
This book helps database and system administrators succeed in managing Oracle Application Express (APEX) environments. Focus is on creating the right combination of scalability, high-availability, ...