OraFAQ Forum: Weblogic & Application Server » How to get Client IP Address from stored Procedure/Function

Home » Fusion Middleware & Colab Suite » Weblogic & Application Server » How to get Client IP Address from stored Procedure/Function

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to get Client IP Address from stored Procedure/Function [message #442793]

Wed, 10 February 2010 10:27

aljabali
Messages: 53
Registered: July 2008

Member

I am using Application Server 10, Database 10g, Oracle Developer Forms 10g .
I want to get Client IP address from a stored Procedure/Function or database trigger, when using SYS_CONTEXT it returns App Server IP, WebUtil is, I have to use in Form but I want to write a stored procedure/function in DB and calling it from Form to get Client's IP address, how I can do it??

please help with an example.

thanks and regards.

Report message to a moderator

Re: How to get Client IP Address from stored Procedure/Function [message #442794 is a reply to message #442793]

Wed, 10 February 2010 11:08

ThomasG
Messages: 3212
Registered: April 2005
Location: Heilbronn, Germany

Senior Member

You (still?) can't.

Report message to a moderator

Re: How to get Client IP Address from stored Procedure/Function [message #442844 is a reply to message #442793]

Wed, 10 February 2010 23:42

aljabali
Messages: 53
Registered: July 2008

Member

Why can't ???????????????????

THANKS

Report message to a moderator

Re: How to get Client IP Address from stored Procedure/Function [message #442862 is a reply to message #442844]

Thu, 11 February 2010 00:47

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Perhaps you can, but we don't know how. If you ever find a way, please, share the knowledge.

(By the way, I have a feeling that you didn't read a thread hidden behind Thomas' link, did you?)

Report message to a moderator

Re: How to get Client IP Address from stored Procedure/Function [message #442897 is a reply to message #442844]

Thu, 11 February 2010 03:43

ThomasG
Messages: 3212
Registered: April 2005
Location: Heilbronn, Germany

Senior Member

aljabali wrote on Thu, 11 February 2010 06:42

Why can't ???????????????????

Why can't pigs fly?

Why can't cows jump to the moon?

The database can't see the "client", the database only sees the application server. So it's technically impossible for the database to know the "client" IP.

Report message to a moderator

Re: How to get Client IP Address from stored Procedure/Function [message #442956 is a reply to message #442897]

Thu, 11 February 2010 10:59

andrew again
Messages: 2577
Registered: March 2000

Senior Member

http://forums.oracle.com/forums/thread.jspa?messageID=1773034

I have no recent Forms experience, but in general, if your middle tier doesn't relay the user's IP address to the database, then PL/SQL can't get that info (as mentioned above). The workaround is to get something on your user's client to detect the IP and then directly pass it to the database as a parameter in some pl/sql call.

[Updated on: Thu, 11 February 2010 11:08]

Report message to a moderator

Previous Topic:	Creating a new user to access OAS
Next Topic:	Killing Oracle HTTP Server child process

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Dec 10 02:44:24 CST 2024