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.