If recompiling the package results in compilation errors, then the database returns an error and the body remains invalid. All side effects caused by the code such as the creation of new variables propagate to the calling environment. Keyword and Parameter Descriptions schema Specify the schema containing the package. If recompiling the body results in compilation errors, then the database returns an error message and the body remains invalid. During recompilation, the database drops all persistent compiler switch settings, retrieves them again from the session, and stores them at the end of compilation. See Creating a Package: If the code calls dbBreak , execution of the code stops and the transaction is silently aborted.