ORA-04098: 触åå¨æ æä¸æªéè¿éæ°éªè¯
å¯è½æ¯è¿æ ·çæ
åµï¼
第ä¸ï¼ç¨æ·æ¯å¦ææ§è¡è§¦åå¨çæé
æ¥çç¨æ·æ¯å¦ææéæ§è¡è§¦åå¨ï¼å¦æ没ææéï¼é£ä¹å°±ç®æ¯æ£ç¡®ç触åå¨ä¹ä¼è§¦åé误
select owner, object_name, object_type, status from dba_objects where object_name = '<TRIGGER_NAME>';
第äºï¼å建çåºåã触åå¨ã表æ¯å¦å¨åä¸ç¨æ·ä¸é¢
第ä¸ï¼å¨è§¦åå¨ä¸éè¦å åå·ï¼è§¦åå¨çé£å¥åºè¯¥æ¯è¿æ ·åçããä½ è¯è¯æ¯å¦æ£ç¡®ï¼ï¼
select seq_user.nextval into :new.id from sys.dual;
温馨提示:内容为网友见解,仅供参考