$page_title = $titlebar_text; $header_bar_text = $titlebar_text; ///////////////////////////////////// // get header include('rlib_header.php'); // print << Oracle OWA_SEC Version 11.1  
General Information
Source {ORACLE_HOME}/rdbms/admin/pubsec.sql
{ORACLE_HOME}/rdbms/admin/privtext.sql
First Availability
Name Data Type Value
CUSTOM INTEGER 4
GLOBAL INTEGER 2
NO_CHECK INTEGER 1
PER_PACKAGE INTEGER 3
Constants 8.1.7
Dependencies
HTP OWA_PATTERN
 
GET_CLIENT_HOSTNAME
Obtains the Web client's Host Name owa_sec.get_client_hostname RETURN VARCHAR2;
Calls owa.hostname
 
GET_CLIENT_IP
Obtains the Web client's IP Address owa_sec.get_client_ip RETURN owa_util.ip_address;
Calls owa.ip_address

If address is 192.168.1.118 then
ip_address(1) = 192
ip_address(2) = 169
ip_address(3) =   1
ip_address(4) = 118


set serveroutput on

DECLARE
 iparray owa_util.ip_address;
BEGIN
  iparray := owa_sec.get_client_ip;
  dbms_output.put_line(iparray(1));
  dbms_output.put_line(iparray(2));
  dbms_output.put_line(iparray(3));
  dbms_output.put_line(iparray(4));
END;
/
 
GET_PASSWORD
Obtains the Web client's password owa_sec.get_password RETURN VARCHAR2;
Calls owa.password
 
GET_USER_ID
Obtain the Web client's authentication user identifier owa_sec.get_user_id RETURN owa.user_id;
Calls owa_user_id
 
SET_AUTHORIZATION
Specifies the PL/SQL Agent's authorization scheme  owa_sec.set_authorization(scheme IN INTEGER);
See OWA_CUSTOM package Initialization Section (link below)
 
SET_PROTECTION_REALM
Specifies the dynamic page's protection real owa_sec.set_protection_realm(realm IN VARCHAR2);
-- source code
BEGIN
  owa.protection_realm := realm;
END;
 
Related Topics
OWA
OWA_CUSTOM
OWA_CX
OWA_OPT_LOCK
OWA_TEXT
OWA_UTIL
  EOM; ///////////////////////////////////// // get footer include('rlib_footer.php'); ?>