Home » Fusion Middleware & Colab Suite » Weblogic & Application Server » How to get Client IP Address from stored Procedure/Function
How to get Client IP Address from stored Procedure/Function [message #442793] Wed, 10 February 2010 10:27 Go to next message
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.
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 Go to previous messageGo to next message
ThomasG
Messages: 3211
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
You (still?) can't.

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 Go to previous messageGo to next message
aljabali
Messages: 53
Registered: July 2008
Member
Why can't ???????????????????

THANKS
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 Go to previous messageGo to next message
Littlefoot
Messages: 21806
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?)
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 Go to previous messageGo to next message
ThomasG
Messages: 3211
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.
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 Go to previous message
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:
  


Current Time: Thu Mar 28 07:11:08 CDT 2024