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

IN -> Oracle_01.sql

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

Snowflake

Snowflake

OUT -> Oracle_01.sql

CREATE OR REPLACE PROCEDURE SCHEMA1_PKG1.procedure1 ()
RETURNS VARCHAR
LANGUAGE SQL
COMMENT = '{"origin":"sf_sc","name":"snowconvert","version":{"major":1, "minor":0},{"attributes":{"component":"oracle"}}'
EXECUTE AS CALLER
AS
$$
    BEGIN
        --** SSC-FDM-OR0035 - CHECK UDF IMPLEMENTATION FOR DBMS_OUTPUT.PUT_LINE_UDF. **
        CALL DBMS_OUTPUT.PUT_LINE_UDF('hello world');
    END;
$$;

Known Issues

No issues were found.

Related EWIs

1. SSC-FDM-0015:

2. SSC-FDM-OR0035: DBMS_OUTPUT.PUTLINE check UDF implementation