how can we use, " Create and replace trigger"
Posted: Sat Jul 25, 2009 11:06 am
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
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