4 Replies Latest reply on Feb 1, 2017 10:26 AM by gadeyne.bram

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

    gadeyne.bram Master

      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