DBA Catalog

Package compilation failed on one of our database with error: PLS-00907 : cannot load library unit schema.package during compiling some pa...

When developer is trying to recompile PL/SQL package, session hangs until get this error: ORA-04021: timeout occurred while waiting to lock...

EXECUTE IMMEDIATE Feature allows you to execute DYNAMIC SQL Statements inside the PL/SQL Procedure, but here I''ll show you interest...