ignore missing packages

Description

By default, the ORA connector generates an error when a stored package does not exist in the database. This happens when Uniface calls the PACKAGE_VERSION procedure after it has checked whether a table exists. If, however, the connector option ignore missing packages is set, and the call to the PACKAGE_VERSION procedure fails abnormally, Uniface ignores the package, does not raise an error, and continues as normal using only dynamic SQL for the table concerned.

You can selectively disable the use of stored packages by not creating them for some tables, and by setting the ignore missing packages option. This option is also useful when an application primarily accesses a database with the Procedural option, but it must also access a database without this option.

The disadvantages of the ignore missing packages option are:

• If a stored package is available, but an abnormal error occurs when calling the PACKAGE_VERSION procedure, the error goes unnoticed.

• When ignore missing packages is in use, you cannot use the disable checks option. This means that you do not gain the performance improvement provided by disable checks.