Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

get client IP address through database trigger in application server

736299Nov 22 2009 — edited Nov 22 2009

Hi,
I want to get Client IP address through database trigger when i logon in the application server.
when i use

select SYS_CONTEXT('USERENV', 'IP_ADDRESS', 15) PC_IP_ADDRESS from dual;

This command,
when i connect through toad or sql plus it will show me Client IP Address.
when i connect through application server it will show me Application Server IP address.

how can i get client ip address. Help me

Regards
Ahmad

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 20 2009

Added on Nov 22 2009

#general-database-discussions

9 comments

5,298 views