We currently use triggers with static if..then..else statements to determine which partition the data goes into. Would there be a performance impact if we were to use dynamic sql to achieve the same ?. The issue with static triggers is the maintenance overhead of having to redefine the triggers periodically. The dynamic sql is simple and involves building a sql string with just a to_char(date_Field) to determine which partition the data goes into and the trigger will never have to be re-defined.
There will be some performance degradation, but you'll have to test measure it and decide if it is acceptable to you vs. the maintenance overhead.