BODY

Description

The header of the PACKAGE BODY is removed and each procedure or function definition is transformed into a standalone function or procedure.

CREATE PACKAGE SYNTAX

CREATE [ OR REPLACE ]
[ EDITIONABLE | NONEDITIONABLE ]
PACKAGE BODY plsql_package_body_source

Sample Source Patterns

The following queries were transformed with the PackagesAsSchema option disabled.

Oracle

Query

CREATE OR REPLACE PACKAGE BODY SCHEMA1.PKG1 AS
	PROCEDURE procedure1 AS
		BEGIN
			dbms_output.put_line('hello world');
		END;
END package1;

Snowflake

Snowflake

CREATE OR REPLACE PROCEDURE SCHEMA1_PKG1.procedure1 ()
RETURNS VARCHAR
LANGUAGE SQL
EXECUTE AS CALLER
AS
$$
BEGIN
        /*** MSC-WARNING - MSCEWI1020 - CUSTOM UDF 'DBMS_OUTPUT.PUT_LINE' INSERTED. ***/
        /*** MSC-WARNING - MSCEWI3115 - CHECK UDF IMPLEMENTATION FOR DBMS_OUTPUT.PUT_LINE. ***/
        CALL DBMS_OUTPUT.PUT_LINE('hello world');
END;
$$;

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.