Oracle | OWA

Oracle OWA Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai will be available on generic Linux platforms in January and soon on AIX and Windows

Purpose Support package for the Oracle Web Agent (OWA).

AUTHID DEFINER

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_LOB	OWA_CUSTOM	OWA_UTIL
DBMS_STANDARD	OWA_CX	PLITBLM
HTP	OWA_SEC

Documented No

First Available 8.1.7

Security Model Owned by SYS with EXECUTE granted to PUBLIC

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 (new 23ai overload)

Get the output from the user's PL/SQL

Overload 1 owa.get_page( l_clob OUT NOCOPY CLOB, l_text OUT NOCOPY VARCHAR2);

TBD

Overload 2 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;

      

      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