CREATE OR REPLACE PROCEDURE TOT.proc_test_variant (IN PAR1 INT, IN PAR2 INT , IN PAR3 DATE, out PAR4 table)
language sql
dynamic result sets 1
begin
  select VAR_DATE from table(TOT.VAR(11111,1,'2012-11-30'));
end;

select * from table (TOT.proc_test_variant(11111,1,'2012-11-30'))

CREATE OR REPLACE PROCEDURE TOT.proc_test_variant (IN PAR1 INT, IN PAR2 INT , IN PAR3 DATE, out PAR4 table)
language sql
dynamic result sets 1
begin
  --select VAR_DATE from table(TOT.VAR(11111,1,'2012-11-30'));
  select DISTINCT BOOK_DAT from TOT.BANKROLL_SDEP
  into PAR4;
end;

select * from PAR4;