jorgehcb
9/16/2016 - 6:18 PM

[Oracle] Crear procedure retornando recordset

Crear procedure retornando recordset

create or replace PROCEDURE pr_relatorio_custodia (cliente IN INTEGER,
                      results IN OUT SYS_REFCURSOR) AS 
BEGIN 
  OPEN results FOR
    select * from tscclibol;
END;