disable packages

Do not generate or use stored packages.

USYS$ORA_PARAMS = disable packages

USYS$ORA_PARAMS = dpa

Description

If you set the disable packages option, the use of stored packages is disabled: If the use of stored packages is disabled, the behavior of Uniface changes as follows:

  • Uniface does not generate CREATE OR REPLACE PACKAGE and CREATE OR REPLACE PACKAGE BODY statements when you use the Create Table facility.

  • Uniface does not create package specifications and package bodies when it creates tables on the fly.

  • Uniface does not attempt to call procedures, but uses only dynamic SQL, even when the packages exist in the database.

  • The ORA connector does not display the current major and minor package version in the message frame when the application is monitoring SQL.

You must disable the use of stored packages when connecting to an Oracle server which does not have the Procedural option. You may want to disable the use of stored packages when working in a development environment where the modeled objects changes frequently, thus causing extra overhead for recreating the packages which are dependent on the modeled objects.

Related Topics