plsql - Will Static sql (as opposed to Dynamic SQL) invalidate other packages in Oracle -
hi if write custom package nothing static sql in it, invalidate other package. (other third party packages shipped wrapped code).
a co worker suggests re write custom package in dynamic sql, , not see problem. find hard believe because third party packages not dependent on custom package, compiled package should stay compiled, regardless.
-thank you
it invalidate packages included custom package dependency.
you should able prove co-worker (and yourself) in test environment.
Comments
Post a Comment