Page 1 of 1

how can we use, " Create and replace trigger"

Posted: Sat Jul 25, 2009 11:06 am
by sarahaman
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

Posted: Tue Sep 01, 2009 9:20 am
by mirza_rehan
Dear Sarah,

This is Database Trigger, we did not use it on forms. If any confusion please reply.

Regards,
Rehan Mirza