我不完全确定为什么会出现这种情况。当我运行以下命令时:
ALTER TRIGGER ORIGDV87.UPDATE_TEAM_GROUP_TRIGGER DISABLE/ENABLE
我能理解它是如何改变触发器的。我正在尝试从Java程序中自动执行此操作:
private void trigger_alter(Connection con, String flag) throws Exception
{
Query query = new Query(con);
String selectSql = "select table_owner, trigger_name from user_triggers";
Query queryTrg = new Query(con);
query.executeQuery(selectSql);
while(query.next()) {
int i = 0;
String table_owner = query.getColValue("table_owner");
String trigger_name = query.getColValue("trigger_name");
String triggerSql = "ALTER TRIGGER " + table_owner + "." + trigger_name + " "+ flag ;
System.out.println( triggerSql);
queryTrg.executeQuery(triggerSql);
}
log_obj.FmtAndLogMsg("All triggers have been " + flag+ "D");
}
我遇到了这个异常:
2013/02/26 10:38:56.795 TableConverter: ERROR main() occurred: java.lang.Exception: Error executing query: ALTER TRIGGER XXXX.UPDATE_TEAM_GROUP_TRIGGER DISABLE error=java.sql.SQLException: ORA-01003: no statement parsed
这是一个Oracle数据库,在Solaris系统中进行尝试。