Oracle PLSQL Demo

CREATE OR REPLACE PACKAGE BODY temp_package_demo is

    FUNCTION f_demo(userid NUMBER) RETURN BOOLEAN IS
        v_temp varchar2(1);
    BEGIN
        SELECT 1 INTO v_temp FROM scott.emp WHERE empno = userid;
        RETURN TRUE;
    EXCEPTION
        WHEN NO_DATA_FOUND THEN
            RETURN FALSE;
    END;

    PROCEDURE p_demo_1(userid NUMBER DEFAULT v_demo, sal number) is
        v_temp varchar2(1);
    BEGIN
        SELECT 1 INTO v_temp FROM scott.emp WHERE empno = userid;
    
    EXCEPTION
        WHEN NO_DATA_FOUND THEN
            RAISE_APPLICATION_ERROR(-20011, 'Not found');
    END;

END temp_package_demo;