My Oracle Support Banner

How to Determine Client IP-address,Language & Territory and Username for Current Session (Doc ID 120797.1)

Last updated on JUNE 11, 2023

Applies to:

Oracle Database - Enterprise Edition - Version 7.0.16.0 and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.

Purpose

 Purpose:
========

Sometimes developers want to catch session-dependent parameters for
application logic:

o Client IP-address.
o Session's Language and Territory settings
o Get the current user when using invoker-rights.

The purpose of this article is to explain how to determine the values
of the above three parameters.

Scope

 Scope & Application:
====================

This article is intended for use by all Oracle users.

Details

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.