OraFAQ Forum: Application Express, ORDS & MOD_PLSQL » Maintaining CONSISTENCY AMONG USERS

Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » Maintaining CONSISTENCY AMONG USERS

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Maintaining CONSISTENCY AMONG USERS [message #228346]

Mon, 02 April 2007 11:19

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

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.

Attachment: cookie_sql.zip
(Size: 1.45KB, Downloaded 1854 times)

Report message to a moderator

Re: Maintaining CONSISTENCY AMONG USERS [message #233624 is a reply to message #228955]

Thu, 26 April 2007 23:37

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

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

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

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Jan 07 16:38:50 CST 2025