Package creation in Oracle is a TWO step Process.
1.Declaration of Package
2.Definition of Package
Declaration of Package
CREATE OR REPLACE PACKAGE TEST IS
PROCEDURE JUNITPROC(C OUT SYS_REFCURSOR);
END TEST;
Definition of Package
CREATE OR REPLACE PACKAGE BODY TEST IS
PROCEDURE JUNITPROC(C OUT SYS_REFCURSOR) IS
BEGIN
OPEN C FOR
SELECT 78985450.1245487986418648 DECIMAL_VAL FROM DUAL;
END JUNITPROC;
END TEST;
Pingback: Stephen