APEX文件上传下载
按照文档 http://docs.oracle.com/cd/B31036_01/doc/appdev.22/b28839/up_dn_files.htm的步骤创建上传下载文件的应用程序,文件的内容即可以存放于默认的视图APEX_APPLICATION_FILES或者自己定制的表格中,例如oehr_file_subject,如果自己定义的表格,需要有一个列是BLOB类型
运行会出现403 error
原因是:
In Oracle XE (production) you will have to "allow" a stored procedure to
be called through the embedded plsql gateway (DBMS_EPG) due to a stricter security
control.
conn SYSTEM/<pwd>@xe
alter session set current_schema=FLOWS_020100;
CREATE OR REPLACE function wwv_flow_epg_include_mod_local(
procedure_name in varchar2)
return boolean
is
begin
按照文档 http://docs.oracle.com/cd/B31036_01/doc/appdev.22/b28839/up_dn_files.htm的步骤创建上传下载文件的应用程序,文件的内容即可以存放于默认的视图APEX_APPLICATION_FILES或者自己定制的表格中,例如oehr_file_subject,如果自己定义的表格,需要有一个列是BLOB类型
![](http://photos1.blogger.com/blogger/379/2094/1600/SNAG-0000.2.jpg)
运行会出现403 error
原因是:
In Oracle XE (production) you will have to "allow" a stored procedure to
be called through the embedded plsql gateway (DBMS_EPG) due to a stricter security
control.
conn SYSTEM/<pwd>@xe
alter session set current_schema=FLOWS_020100;
CREATE OR REPLACE function wwv_flow_epg_include_mod_local(
procedure_name in varchar2)
return boolean
is
begin