upgrade packages

Generate packages only with the Create Table utility, not tables and indexes.

USYS$ORA_PARAMS = upgrade packages

USYS$ORA_PARAMS = up

Description

If the connector option upgrade packages is set, the Create Table utility generates only the CREATE OR REPLACE PACKAGE and CREATE OR REPLACE PACKAGE BODY statements, and not the CREATE TABLE and CREATE INDEX statements which are normally generated. This option does not affect the behavior of Uniface when creating tables, indexes and packages on the fly.

The SQL script generated by the Create Table utility when this option is set can only be executed on a schema if the associated tables already exist in that schema. When you attempt to create the packages in a schema where the associated tables do not yet exist, obscure PL/SQL compilation errors occur.

Related Topics