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