Editor doesn't split that package

Toad for Oracle - Beta
1

CREATE OR REPLACE PACKAGE pkg_tst
IS
TYPE numberarraytype IS TABLE OF NUMBER
INDEX BY PLS_INTEGER;

PROCEDURE prc_tst (p_arr IN numberarraytype DEFAULT CAST (NULL AS numberarraytype));

END;
/

CREATE OR REPLACE PACKAGE BODY pkg_tst
IS
PROCEDURE prc_tst (p_arr IN numberarraytype DEFAULT CAST (NULL AS numberarraytype))
IS
BEGIN
NULL;
END;
END;
/

but PL/SQL Developer splits this package…

2

Sorry…

CREATE OR REPLACE PACKAGE pkg_tst
IS
TYPE numberarraytype IS TABLE OF NUMBER
INDEX BY PLS_INTEGER;

PROCEDURE prc_tst (p_arr IN numberarraytype DEFAULT CAST (NULL AS numberarraytype));

END;
/

CREATE OR REPLACE PACKAGE BODY pkg_tst
IS
PROCEDURE prc_tst (p_arr IN numberarraytype DEFAULT CAST (NULL AS numberarraytype))
IS
BEGIN
NULL;
END;
END;
/

3

Thanks. I see this and it’s been logged.

Michael