| General Information |
| Source |
{ORACLE_HOME}/rdbms/admin/pubowa.sql |
| First Availability |
8.1.7 |
| Constants |
| Name |
Data type |
Value |
| BS_CHAR |
VARCHAR2(1) |
owa_cx.bs_char |
| HT_CHAR |
VARCHAR2(1) |
owa_cx.ht_char |
| NL_CHAR |
VARCHAR2(1) |
owa_cx.nl_char |
| SP_CHAR |
VARCHAR2(1) |
owa_cx.sp_char |
| XP_CHAR |
VARCHAR2(1) |
owa_cx.xp_char |
|
| Dependencies |
| HTP |
PLITBLM |
| OWA_CUSTOM |
WWV_FLOW_PAGE_CACHE_API |
| OWA_CX |
WWV_FLOW_SC_TRANSACTIONS |
| OWA_SEC |
WWV_FLOW_UTILITIES |
| OWA_UTIL |
|
|
| Data Types |
type vc_arr IS TABLE OF VARCHAR2(32000) INDEX BY BINARY_INTEGER;
type nc_arr IS TABLE OF NVARCHAR2(16000) INDEX BY BINARY_INTEGER;
type raw_arr IS TABLE OF raw(32000) INDEX BY BINARY_INTEGER;
cgi_var_name vc_arr;
cgi_var_val vc_arr;
num_cgi_vars NUMBER;
auth_scheme INTEGER;
hostname VARCHAR2(255);
ip_address owa_util.ip_address;
password VARCHAR2(255);
protection_realm VARCHAR2(255);
user_id VARCHAR2(255); |
| Security Model |
Owned by SYS with no privs granted |
| Subprograms |
|
| |
| GET_LINE |
| Get the output from the user's PL/SQL |
owa.get_line(irows OUT INTEGER) RETURN VARCHAR2; |
| TBD |
| |
| GET_PAGE |
| Get the output from the user's PL/SQL |
owa.get_page(
thepage OUT NOCOPY htp.htbuf_arr,
irows IN OUT INTEGER); |
| TBD |
| |
| GET_PAGE_CHARSET_CONVERT |
| Start of OAS specific helper procedures |
owa.get_page_charset_convert(
thepage OUT NOCOPY htp.htbuf_arr,
irows IN OUT INTEGER,
charset IN VARCHAR2 ); |
| TBD |
| |
| GET_PAGE_RAW |
| This is the raw interface to match HTP |
owa.procedure get_page_raw(
thepage OUT NOCOPY htp.htraw_arr,
irows IN OUT INTEGER); |
| TBD |
| |
| INITIALIZE |
| called when a DCD is invoked for the first time when PL/SQL Agent starts up |
owa.initialize RETURN INTEGER; |
SELECT owa.initialize
FROM dual; |
| |
| INIT_CGI_ENV |
Initialize the CGI environment variables
Overload 1 |
owa.init_cgi_env(param_val IN vc_arr); |
| TBD |
| Overload 2 |
owa.init_cgi_env(
num_params IN NUMBER,
param_name IN vc_arr,
param_val IN vc_arr); |
| TBD |
| |
| RESET_GET_PAGE |
| Undocumented |
owa.reset_get_page; |
| exec owa.reset_get_page; |
| |
| SET_PASSWORD |
| Set package globals without crashing |
owa.set_password(pwd in VARCHAR2); |
| TBD |
| |
| SET_TRANSFER_MODE |
| Enable raw transfer mode |
owa.set_transfer_mode(tmode in VARCHAR2); |
| TBD |
| |
| SET_USER_ID |
| Set package globals without crashing |
owa.set_user_id(usr in VARCHAR2); |
| TBD |
