Home » Developer & Programmer » Forms » how can we use, " Create and replace trigger" in Form?
how can we use, " Create and replace trigger" in Form? [message #415158] Sat, 25 July 2009 08:34 Go to next message
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 Go to previous messageGo to next message
Littlefoot
Messages: 20901
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.
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 Go to previous messageGo to next message
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 Go to previous message
cookiemonster
Messages: 12422
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.
Previous Topic: Oracle forms Encountered an error
Next Topic: where I can get icons for forms
Goto Forum:
  


Current Time: Sun Dec 11 00:25:55 CST 2016

Total time taken to generate the page: 0.07478 seconds