OraFAQ Forum: Forms » how can we use, " Create and replace trigger" in Form?

Home » Developer & Programmer » Forms » how can we use, " Create and replace trigger" in Form?

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

how can we use, " Create and replace trigger" in Form? [message #415158]

Sat, 25 July 2009 08:34

Sarah Aman
Messages: 80
Registered: July 2009

Member

Hi all.

can anyone guide me how can we use the following trigger in Form?

CREATE OR REPLACE TRIGGER sara.after_logon_trg
AFTER LOGON ON sara.SCHEMA
BEGIN
DBMS_APPLICATION_INFO.set_module(USER, 'Initialized');
EXECUTE IMMEDIATE 'ALTER SESSION SET current_schema=sara1;
END;

thanks in advance

Sarah

[Updated on: Sat, 25 July 2009 08:37]

Report message to a moderator

Re: how can we use, " Create and replace trigger" in Form? [message #415174 is a reply to message #415158]

Sat, 25 July 2009 15:40

Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

It is executed upon logging on. You don't have to do anything, it will be executed by itself.

Report message to a moderator

Re: how can we use, " Create and replace trigger" in Form? [message #415186 is a reply to message #415174]

Sun, 26 July 2009 00:47

Sarah Aman
Messages: 80
Registered: July 2009

Member

dear sir.

thanks for reply but its for mentioned user not for all, i want to make for all users after logging it give access to all users.

can u guide me more please ?

Sarah

[Updated on: Sun, 26 July 2009 00:49]

Report message to a moderator

Re: how can we use, " Create and replace trigger" in Form? [message #415322 is a reply to message #415158]

Mon, 27 July 2009 04:44

cookiemonster
Messages: 13938
Registered: September 2008
Location: Rainy Manchester

Senior Member

You're going to have to be clearer in what you want this trigger to do because I'm not sure what your requirement is.

Report message to a moderator

Previous Topic:	Oracle forms Encountered an error
Next Topic:	where I can get icons for forms

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 09:53:37 CDT 2024