Jalp

Procedure - IN ; OUT

  • CREATE OR REPLACE  PROCEDURE get_sal
    ( p_ar1 IN NUMBER, 
      p_ar2 OUT NUMBER )
    IS 
    BEGIN 
      
     SELECT sal INTO p_ar2 FROM emp WHERE empno = p_ar1; 
     EXCEPTION
      WHEN NO_DATA_FOUND THEN 
       p_ar2 := 0;
    END; 
    				

Procedure - IN/OUT

  • CREATE OR REPLACE  PROCEDURE retorna_salario
    ( p_ar1 IN OUT NUMBER )
    IS 
    BEGIN 
      
     SELECT sal INTO p_ar1 FROM emp WHERE empno = p_ar1; 
     EXCEPTION
      WHEN no_data_found THEN 
       p_ar1 := 0;
    END retorna_salario; 
    				

Função Recursiva

Dependência Indireta