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