SET TERM ^ ;

CREATE OR ALTER PACKAGE TEST_PKG
AS
BEGIN
    PROCEDURE DO_WORK;
END^

RECREATE PACKAGE BODY TEST_PKG
AS
BEGIN
    PROCEDURE DO_WORK
    AS
    BEGIN
    END
END^

SET TERM ; ^

SET TERM ^ ;

CREATE OR ALTER PACKAGE PKG2
AS
BEGIN
    PROCEDURE DO_ALL;
END^

RECREATE PACKAGE BODY PKG2
AS
BEGIN
    PROCEDURE DO_ALL
    AS
    BEGIN
        EXECUTE PROCEDURE TEST_PKG.DO_WORK;
    END
END^

SET TERM ; ^

PROCEDURE DO_ALL
    AS
    BEGIN
        EXECUTE PROCEDURE TEST_PKG.DO_WORK;
    END

Undefined name.
Dynamic SQL Error.
SQL error code = -204.
Procedure unknown.
TEST_PKG.DO_WORK.