Upgrading SQL*Plus Scripts and PL/SQL after Upgrading Oracle Database
To use features and functions of the new Oracle Database release, you must change existing SQL scripts to use the syntax of the new Oracle Database release.
If existing SQL scripts do not use features and functions of the new Oracle Database release, then they run unchanged on the new Oracle Database release, and require no modification.
Be aware that because of improved error checking in the new Oracle Database release, it may identify errors at compile time rather than at run time.
Parent topic: Upgrading Applications After Upgrading Oracle Database