Variable "CURRENT_BASE" dans un Trigger
Bonjour,
J'ai besoin de mettre en place des triggers qui centralisent des informations de plusieurs bases sur une base globale ...
Contrainte : j'ai besoin de stocker dans la base globale le nom de la base "fille" ...
Existe-t-il une variable du genre CURRENT_BASE qui permettrait d'ecrire un truc du genre :
CREATE TRIGGER ma_base.mon_trigger BEFORE INSERT
ON ma_base.ma_table FOR EACH ROW
INSERT INTO ma_base_globale.ma_table_globale SELECT CURRENT_BASE FROM blabla ...
et ou "CURRENT_BASE" prendrait la valeur de "ma_base" ?
Subject
Views
Written By
Posted
Variable "CURRENT_BASE" dans un Trigger
4480
October 16, 2006 03:16AM
2771
October 19, 2006 02:07PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.