CODE EXAMPLE FOR SQL

oracle pl/sql package

create or replace package test_pkg as
    procedure print (line in varchar);
end test_pkg;

create or replace package body test_pkg as
    procedure print (line in varchar) is
    begin
        DBMS_OUTPUT.PUT_LINE(line);
    end print;
end test_pkg;

begin
    test_pkg.print('Test');
end;