Hi,

Is it possible to use an interval type as an input parameter in a virtual procedure?

I'm trying to do something like this:

exec v_proc_a(SQL_TSI_HOUR,3,12345)

In procedure v_proc_a with these parameters:

interval sometype; -- what would the type be here?

unit integer;

patientid integer;

I'd like to execute something like

BEGIN

     LOOP ON select datetime as from,TIMESTAMPADD(interval, unit, datetime) as validuntil from monitorvalues mv where mv.patientid = patientid as cur1

     BEGIN

          ...

     END

END