Results 1 to 5 of 5
  1. #1
    Join Date
    Aug 2007
    Posts
    6

    Unanswered: Client IP address

    Hi,

    I am using forms 9i on the server for deploying a project on the client.
    When a report is being developed it is getting created on the server side.
    Now I need to find the IP address of the client so that I can give their local path to create the report.

    I tried using SYS_CONTEXT function. But it is giving only the IP address of the server.

    Can anyone help me to solve this problem of how to get the IP address of the Client.


    Thank you

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >Can anyone help me to solve this problem of how to get the IP address of the Client.
    Record the client IP# in the middle zone.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    Check this article; perhaps you'll find something interesting.

    Saying that SYS_CONTEXT didn't help - IP_ADDRESS shows the IP address of the machine from which the client is connected. Is this not what you are looking for?

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Littlefoot,
    In a 3 tier application, at best SYSCONTEXT will obtain the IP# of the Application Server of the middle tier.
    If in a 3 tier application then the middle tier code must obtain the IP# of the browser client & pass it along or make it available to the code running inside the DB server; say via CLIENT_INFO field within V$SESSION.


    HAND!
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  5. #5
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    I see ... thank you for the explanation!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •