How to write down a client IP in an Oracle database variable

[dasivon]

Hi,
I need to pick up a client IP address and write it down in an Oracle database package variable. How to do that?
I'm an Oracle developer and a rookie in Java Script, so please be patient with me.

Thanks.

[pyro]

What language are you using to write the the DB? JavaScript is not capable of writing to external files, so you will want to use a server side language...

[dasivon]

When a user log in into Oracle Discoverer I need to pick up his IP address, username... etc. and write them down in a database. I've created a database function for insert into database table, edited the XML and XSL files on the Oracle application server, make some changes and pick up other variables that I need, but I don't know how to get user's IP (JavaScript, I suppose, to save it in a variable in a XSL file) and how to write it down in a database package variable (or to call database function for insert into database).

[Khalid Ali]

As pyro mentioned,JavaScript is not the scripting language for that purpose,heck it doesn't even have the functionality to perform such tasks.
You will need to use some programming language, such as Java(since java is integrated with oracle aplications already).

[olerag]

As pyro and Khalid have mentioned, don't expect Javascript
(client-side script language) to perform server-side Oracle
DML.

How are you creating your web pages (Java servlet OR
Oracle's OWA package suite)?

From either, your server-side program code will need to
capture your web information, pass the info to Oracle
stored "built-in's" (maybe), have Oracle perform the
necessary DML, and then re-display the browser page(s)
as needed.