Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » Maintaining CONSISTENCY AMONG USERS
Maintaining CONSISTENCY AMONG USERS [message #228346] Mon, 02 April 2007 11:19 Go to next message
oracle_dev
Messages: 24
Registered: April 2007
Junior Member
i am creating PL/SQL PSP web pages. I want to create user login page and want to maintain session till that particular user logged out. also when typed http://server name/pagename it should open with login screen.
Thanks in Adv.

Report message to a moderator

Re: Maintaining CONSISTENCY AMONG USERS [message #228955 is a reply to message #228346] Wed, 04 April 2007 12:15 Go to previous messageGo to next message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
Just retrieve the cookie. If value indicates user is logged in, then display one thing else something else. For logout, just set expiry date of cookie or set it to null.

Report message to a moderator

Re: Maintaining CONSISTENCY AMONG USERS [message #233624 is a reply to message #228955] Thu, 26 April 2007 23:37 Go to previous messageGo to next message
oracle_dev
Messages: 24
Registered: April 2007
Junior Member
Thankyou Andrew,

This is another problem
When i tried to use OWA_SEC.GET_CLIENT_IP FUNCTION it is not giving IP address of the client and is there any mechanism, to
get the MAC address also while user is accessing the page by
calling procedure or function.

Report message to a moderator

Re: Maintaining CONSISTENCY AMONG USERS [message #233637 is a reply to message #233624] Fri, 27 April 2007 01:06 Go to previous messageGo to next message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
No, you need to pick from values passed by your browser to the mod_plsql (pl/sql gateway) and pick from one of those that the gateway takes from what the browser provides. See a list by executing owa_util.print_cgi_env;

The IP address is probably the best you can do, but that is sometimes the same for more than one user (in my environment, all users connecting through the same VPN show the same IP. I forget the technical term for it).

Report message to a moderator

Re:owa_util.print_cgi_env [message #234109 is a reply to message #233637] Mon, 30 April 2007 01:16 Go to previous messageGo to next message
oracle_dev
Messages: 24
Registered: April 2007
Junior Member
I executed it. I think some of the procedures in that packages are somehow corrupted.i just executed it on unix . Whether it has to be executed from the browser only? Kindly help me in that. First I want correct the corrupted package.

Report message to a moderator

Re:owa_util.print_cgi_env [message #234242 is a reply to message #234109] Mon, 30 April 2007 10:10 Go to previous message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
please post error message.

You must call it through mod_plsql.

Report message to a moderator

Previous Topic: htmldb (XE) FOP PDF output
Next Topic: PL/SQL Cartridge
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat May 16 19:42:35 CDT 2026
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.