| 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 |
|
| |
| 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; |
Free