Rule for Object in Oracle Package 👉 Key rule in Oracle: · PL/SQL package specs/bodies → can only hold PL/SQL types (records, nested tables, varrays, associative arrays, subtypes, etc.). · SQL schema ...
To store package variables, SSMA for Oracle uses stored procedures that reside in a special ssma_oracle schema along with ssma_oracle.db_storage table. This table is filtered by SPID (session ...
-- raised when a FORALL with SAVE EXCEPTIONS encounters at least one failed statement.