Oracle | OWA

Oracle OWA Version 21c

General Information

Library Note

Morgan's Library Page Header

ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.

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	INITIALIZE	SET_PASSWORD
GET_PAGE	INIT_CGI_ENV	SET_TRANSFER_MODE
GET_PAGE_CHARSET_CONVERT	RESET_GET_PAGE	SET_USER_ID
GET_PAGE_RAW

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;

      

      INITIALIZE

      ----------

      1024

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;

      

      PL/SQL procedure successfully completed.

SET_PASSWORD

Set package globals without crashing owa.set_password(pwd in VARCHAR2);

exec owa.set_password('Temp1Meee');

      

      PL/SQL procedure successfully completed.

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