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

Popular posts from this blog

c++ - Convert big endian to little endian when reading from a binary file -

C#: Application without a window or taskbar item (background app) that can still use Console.WriteLine() -

unicode - Are email addresses allowed to contain non-alphanumeric characters? -