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.

please more clarification as sys_context returns client IP-address what's the usage of the procedure or function and when do you want it to be fired or executed?[spacing][/spacing]

when you use the application system connect the server the SYS_CONTEXT it returns App Server IP