CREATE OR REPLACE PROCEDURE SP_GET_DNIS(P_RETURN OUT VARCHAR,P_IN VARCHAR)
AS
--=====================================================
V_RETURN
VARCHAR(24);
V_ID
NUMBER(10);
--=====================================================
BEGIN
--=====================================================
SELECT TELEPHONE,
ID
INTO V_RETURN,
V_ID
FROM TB_COST
WHERE ID = (SELECT MIN(ID) FROM TB_COST WHERE ISOK = 0 )