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
how can we use, " Create and replace trigger"
-
- Posts: 132
- Joined: Sun Apr 02, 2006 10:36 am
- Location: Pakistan
Who is online
Users browsing this forum: No registered users and 4 guests