The next time one of the invalid stored prepared statements in the
is executed, it will
be recompiled, and a new plan will be generated for it.
Run SYSCS_UTIL.SYSCS_INVALIDATE_STORED_STATEMENTS whenever
you think that your metadata queries or triggers are misbehaving -- for example,
if they throw java.lang.NoSuchMethodError or
java.lang.NoSuchMethodException on execution.
stores plans for
triggers and metadata queries in the database. These should be invalidated
automatically on upgrade and at other necessary times. Should you encounter an
instance where they are not, you have found a bug that you should report, but
one that you can likely work around by running
SYSCS_UTIL.SYSCS_INVALIDATE_STORED_STATEMENTS.