For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!
Hello, everyone! I stucked with porblem. When I try to compile any stored procedure in SQL Developer, my ScriptRunner Task works without break and that's all. It doesn't show any error. What should I do?
If your stored procedures are huge maybe a Java heap space problem ?
Recompiling a stored proc requires an exclusive lock on the meta data object for the stored proc. Sessions using and executing a stored proc, or objects with dependencies on that stored proc, place a shared lock on the stored proc meta data object. This is to prevent runtime issues and errors to occur by changing the code of an in-use stored proc. Thus a recompile session call can wait for an extended time for obtaining an exclusive lock for changing the stored proc.
So, if your database is busy, and your procedures are being used a lot, let me suggest that you use edition-based redefinition to make your changes.
