ORA_CLIENT_IP_ADDRESS returns the client IP address as a VARCHAR2 datatype. : ORA « System Packages « Oracle PL / SQL






  1. Oracle PL / SQL
  2. System Packages
  3. ORA

ORA_CLIENT_IP_ADDRESS returns the client IP address as a VARCHAR2 datatype.

   
SQL>
SQL> DECLARE
  2    ip_address VARCHAR2(11);
  3  BEGIN
  4    IF ora_sysevent = 'LOGON' THEN
  5      ip_address := ora_client_ip_address;
  6      dbms_output.put_line('ip_address:'||ip_address);
  7
  8    END IF;
  9  END;
 10  /

PL/SQL procedure successfully completed.

SQL>
SQL>








Related examples in the same category

1.ORA_DES_ENCRYPTED_PASSWORD returns the DES-encrypted password as a VARCHAR2 datatype
2.ORA_DICT_OBJ_NAME returns an object name as a VARCHAR2 datatype
3.ORA_DICT_OBJ_NAME_LIST: list of object names touched by the triggering event.
4.ORA_DICT_OBJ_OWNER returns an owner of the object acted upon by the event as a VARCHAR2 datatype.
5.ORA_DICT_OBJ_OWNER_LIST returns the number of elements in the list indexed by a PLS_INTEGER datatype.
6.ORA_DICT_OBJ_TYPE returns the datatype of the dictionary object changed by the event as a VARCHAR2 datatype.
7.ORA_GRANTEE returns the number of elements in the list indexed by a PLS_INTEGER datatype.
8.ORA_INSTANCE_NUM returns the current database instance number as a NUMBER datatype.
9.ORA_IS_ALTER_COLUMN returns a true or false value as a BOOLEAN datatype
10.ORA_IS_CREATING_NESTED_TABLE returns a true or false value as a BOOLEAN datatype when you create a table with a nested table.
11.ORA_LOGIN_USER function returns the current schema name as a VARCHAR2 datatype.
12.ORA_PRIVILEGE_LIST returns the number of elements in the list indexed by a PLS_INTEGER datatype.
13.ORA_SERVER_ERROR returns an error number as a NUMBER datatype.
14.ORA_SERVER_ERROR_MSG returns an error message text as a VARCHAR2 datatype.
15.ORA_SYSEVENT function returns the system event that was responsible for firing the trigger as a VARCHAR2 datatype.
16.ORA_WITH_GRANT_OPTION returns a true or false value as a BOOLEAN datatype.
17.The ORA_IS_SERVERERROR returns a true or false value as a BOOLEAN datatype when the error is on the error stack.