Oracle OWA
Version 12.1.0.1

General Information
Library Note Morgan's Library Page Footer
The Library is currently in the process of being upgraded from Oracle Database Version 11.2.0.3 to 12.1.0.1. Demos are being upgraded to reflect the new Container paradigm as well as EBR (Edition Based Redefinition) and may contain references to CDBs, PDBs, and other objects you may not be familiar with such as CDB_OBJECTS_AE: Welcome to 12c.
Purpose Support package for the Oracle Web Agent (OWA).
AUTHID CURRENT_USER
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
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);
Dependencies
HTP OWA_SEC WWV_FLOW_PAGE_CACHE_API
OWA_CUSTOM OWA_UTIL WWV_FLOW_SC_TRANSACTIONS
OWA_CX PLITBLM WWV_FLOW_UTILITIES
Documented No
First Available 8.1.7
Security Model Owned by SYS with no privileges granted
Source {ORACLE_HOME}/rdbms/admin/pubowa.sql
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);
exec owa.set_password('Temp1Meee');
 
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

Related Topics
OWA_COOKIE
OWA_CUSTOM
OWA_CX
OWA_OPT_LOCK
OWA_SEC
OWA_TEXT
OWA_UTIL
Packages

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2014 Daniel A. Morgan All Rights Reserved