FUNCTION Get (
    n_use       IN  number,
    n_int   IN  number,
    o_down OUT varchar2
    )
RETURN INTEGER
AS
    l_Prg VARCHAR2(30) := 'GetUserMappingID';
BEGIN
    -- Verify for required in parameters
    IF  n_use IS NULL OR n_int  IS NULL  THEN
        Raise p_missing_parameters ;
    END IF;

    
    SELECT DOWNS INTO o_down FROM mytable
    WHERE USER=n_use  AND INTE=n_int;

	
		return 0;
	
 
EXCEPTION

    WHEN no_data_found THEN
	RAISE_APPLICATION_ERROR(-20002, 'No Data Found  in '||n_use||' and '||n_int);
        
    WHEN p_missing_parameters THEN
        RAISE_APPLICATION_ERROR(-20001, 'Missing essential parameters in '||l_Prg);
    WHEN OTHERS THEN
        RAISE_APPLICATION_ERROR(-20000, 'DB Error: '||SQLERRM||' IN '||l_Prg);
END Get;