Oracle OWA
Version 19.3

General Information
Library Note Morgan's Library Page Header
For how many years have you been working with physical servers that are starving your database of the memory necessary to deploy important new performance features such as the Result Cache, Memoptimize Pool, In-Memory Aggregation, In-Memory Column Store, and Full Database Caching? Too long? Contact me to learn how to improve all queries ... not just some queries.
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
Built-in Functions
Built-in Packages
OWA_COOKIE
OWA_CUSTOM
OWA_CX
OWA_OPT_LOCK
OWA_SEC
OWA_TEXT
OWA_UTIL
What's New In 18cR3
What's New In 19cR3

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