Oracle Function - 01

CREATE OR REPLACE FUNCTION XXXXXXX.F_CODE_VALUE (     P_CODE IN S_CODE.CODE%TYPE,     P_UP_CODE IN S_CODE.UP_CODE%TYPE ) RETURN VARCHAR2 IS     R_CODE_VALUE S_CODE.CODE_VALUE%TYPE;         BEGIN     SELECT CODE_VALUE INTO R_CODE_VALUE       FROM S_CODE      WHERE 1=1        AND CODE = P_CODE        AND UP_CODE = P_UP_CODE;             RETURN R_CODE_VALUE;         EXCEPTION         WHEN OTHERS THEN             RETURN 'NULL';        END F_CODE_VALUE;

CREATE OR REPLACE FUNCTION YYYYYYY.F_ITEM_PICTUREURL (     P_ITEMID IN ITEM.ITEMID%TYPE ) RETURN VARCHAR2 IS     R_ITEM_PICTUREURL ITEM.PICTUREURL%TYPE;     BEGIN     SELECT PICTUREURL INTO R_ITEM_PICTUREURL       FROM ITEM      WHERE ITEMID = P_ITEMID;         RETURN R_ITEM_PICTUREURL;         EXCEPTION         WHEN OTHERS THEN             RETURN 'NULL'; END F_ITEM_PICTUREURL;