DECLARATION

Description

The declaration is converted to a schema, so each inner element is declared inside this schema. All the elements present in the package are commented except for the VARIABLES which have a proper transformation.

CREATE PACKAGE SYNTAX

CREATE [ OR REPLACE ]
[ EDITIONABLE | NONEDITIONABLE ]
PACKAGE plsql_package_source

Sample Source Patterns

The following queries were transformed with the PackagesAsSchema option disabled.

Oracle

Query

CREATE OR REPLACE PACKAGE SCHEMA1.PKG1 AS
	PROCEDURE procedure1;
END package1;

Snowflake

Query

CREATE SCHEMA IF NOT EXISTS SCHEMA1_PKG1;

/*** MSC-WARNING - MSCEWI3034 - PACKAGE PROCEDURE DECLARATION HEADING IS NOT NECESSARY IN SNOWFLAKE ***/
  /*	PROCEDURE procedure1;*/

Known Issues

No issues were found.

Related EWIs

1. MSCEWI3034: Package procedure declaration heading is not necessary for Snowflake.

2. MSCEWI3056: Snowflake does not support the versioning of objects. Developers should consider alternate approaches for code versioning.