CODE
Oracle Code Library
JOBS
Find Or Post Oracle Jobs
FORUM
Oracle Discussion & Chat
PSOUG Home Code Snippets Oracle Reference Oracle Functions PSOUG Forum Oracle Blogs Bookmark and Share
 
 Search the Reference Library pages:  

Free
Oracle Magazine
Subscriptions
and Oracle White Papers

Oracle OWA
Version 11.1
 
General Information
Source {ORACLE_HOME}/rdbms/admin/pubowa.sql
First Availability 8.1.7
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
Dependencies
APPLICATION_AUTHENTICATION PLITBLM
OWA_CUSTOM WWV_FLOW_PAGE_CACHE_AP
OWA_CX WWV_FLOW_REWRITE_QUERY
OWA_SEC WWV_FLOW_SC_TRANSACTIONS
OWA_UTIL WWV_FLOW_UTILITIES

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);
Security Model 8.1.7
 
GET_LINE
Get the output from the user's PL/SQL owa_custom.get_line(irows OUT INTEGER) RETURN VARCHAR2;
TBD
 
GET_PAGE
Get the output from the user's PL/SQL owa_custom.get_page(
thepage    OUT NOCOPY htp.htbuf_arr,
irows   IN OUT INTEGER);
TBD
 
GET_PAGE_CHARSET_CONVERT
Start of OAS specific helper procedures owa_custom. procedure 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_custom.procedure get_page_raw(
thepage    OUT NOCOPY htp.htraw_arr,
irows   IN OUT INTEGER);
TBD
 
INIT_CGI_ENV
Initialize the CGI environment variables

Overload 1
owa_custom.init_cgi_env(param_val IN vc_arr);
TBD
Overload 2 owa_custom.init_cgi_env(
num_params IN NUMBER,
param_name IN vc_arr,
param_val  IN vc_arr);
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;
 
RESET_GETPAGE
Undocumented owa.reset_get_page;
exec owa.reset_get_page;
 
SET_PASSWORD
Set package globals without crashing owa.set_password(pwd in VARCHAR2);
TBD
 
SET_USER_ID
Set package globals without crashing owa.set_user_id(usr in VARCHAR2);
TBD
 
SET_TRANSFER_MODE
Enable raw transfer mode owa.set_transfer_mode(tmode in VARCHAR2);
TBD
 
Related Topics
OWA_CUSTOM
OWA_CX
OWA_OPT_LOCK
OWA_SEC
OWA_TEXT
OWA_UTIL
 
Home      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us [226 users online]    © 2010 psoug.org