Oracle OWA
Version 12.2.0.1

General Information
Library Note Morgan's Library Page Header
"I spent my entire adult life looking out for the well-being, the training, the equipping of the troops for whom I was responsible. I will not be lectured about what our military needs by a five-deferment draft dodger,"
~ Sen. Tammy Duckworth
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
DBMS_STANDARD OWA_CX OWA_UTIL
HTP OWA_SEC PLITBLM
OWA_CUSTOM    
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
What's New In 12cR1
What's New In 12cR2

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-2017 Daniel A. Morgan All Rights Reserved