Oracle DBA, How To, Error, Cause and Action

ORA-04086: trigger description too long, move comments into triggeringcode

ORA-04086: trigger description too long, move comments into triggering code




Cause: The trigger description is limited to 2000 characters (for dictionary storage reasons). The description does not include the text of the "when" clause or the text of the pl/sql code executed for the trigger.




Action: If the trigger description contains a large comment, move that