请教Trigger的一个有难度的问题[@more@]请问如何在trigger中获取触发这个trigger的
CREATE OR REPLACE TRIGGER TRG_LOG_SQL
BEFORE INSERT
ON MYTABLE
DECLARE
n NUMBER;
stmt varchar2(4000);
sql_text ora_name_list_t;
BEGIN
n := ora_sql_txt(sql_text);
FOR i IN 1..n LOOP
stmt := stmt || sql_text(i);
END LOOP;
INSERT INTO DDL_LOG(DDL_TIME, DDL_USER, DDL_HOST, DDL_IP, DDL_SQL)
VALUES(SYSDATE,USER,SYS_CONTEXT('USERENV','HOST'), SYS_CONTEXT('USERENV','IP_ADDRESS'),stmt);
EXCEPTION
WHEN OTHERS THEN
-- Consider logging the error and then re-raise
RAISE;
END ;SQL?
BEFORE INSERT
ON MYTABLE
DECLARE
n NUMBER;
stmt varchar2(4000);
sql_text ora_name_list_t;
BEGIN
n := ora_sql_txt(sql_text);
FOR i IN 1..n LOOP
stmt := stmt || sql_text(i);
END LOOP;
INSERT INTO DDL_LOG(DDL_TIME, DDL_USER, DDL_HOST, DDL_IP, DDL_SQL)
VALUES(SYSDATE,USER,SYS_CONTEXT('USERENV','HOST'), SYS_CONTEXT('USERENV','IP_ADDRESS'),stmt);
EXCEPTION
WHEN OTHERS THEN
-- Consider logging the error and then re-raise
RAISE;
END ;SQL?
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/658202/viewspace-888824/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/658202/viewspace-888824/