how can we use, " Create and replace trigger"

To discuss Oracle Forms & Reports related technical issues.
Post Reply
sarahaman
Posts: 7
Joined: Fri Jul 17, 2009 4:58 pm
Location: Qatar

how can we use, " Create and replace trigger"

Post 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
mirza_rehan
Posts: 132
Joined: Sun Apr 02, 2006 10:36 am
Location: Pakistan

Post by mirza_rehan »

Dear Sarah,

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

Regards,
Rehan Mirza
Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest