Tag: plsql

  • Compiling Invalid Objects in PL/SQL

    While I do a lot of and prefer PHP and JavaScript development, my daily job has a darker side…PL/SQL. At times the packages that I oversee invalidate during upgrades or poor compilations of a package that ends up having a ripple effect. Here’s a query I wrote to find the invalid objects and generate compile…