CREATE OR REPLACE TRIGGER trace_ddl
AFTER DDL ON DATABASE
DECLARE
sql_text ora_name_list_t;
state_sql VARCHAR2(4000);
BEGIN
FOR i IN 1 .. ora_sql_txt(sql_text) LOOP
state_sql := state_sql || sql_text(i);
END LOOP; --检查 state_sql 就可知道EXCEPTION
WHEN OTHERS THEN
NULL;
END;
AFTER DDL ON DATABASE
DECLARE
sql_text ora_name_list_t;
state_sql VARCHAR2(4000);
BEGIN
FOR i IN 1 .. ora_sql_txt(sql_text) LOOP
state_sql := state_sql || sql_text(i);
END LOOP; --检查 state_sql 就可知道EXCEPTION
WHEN OTHERS THEN
NULL;
END;
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货