CREATE OR REPLACE PACKAGE PKG1 AS
FUNCTION FUNC1(NAME IN VARCHAR2) RETURN NUMBER;
END PKG1;


 CREATE OR REPLACE PACKAGE BODY PKG1 AS
 FUNCTION FUNC1(NAME IN VARCHAR2) RETURN NUMBER IS
 X NUMBER := 12;
 Y NUMBER;
 BEGIN
 Y:=123*X;
 RETURN(Y);
 END FUNC1;
 END PKG1;
 
 SELECT  PKG1.FUNC1('RAJ') FROM DUAL;;
