3 Replies Latest reply on Apr 5, 2018 11:58 AM by Ramesh Reddy

    Generic reference to parameter in procedure

    Martin Jesterhoudt Newbie

      Hi,

       

      Is there a way to referr dynamically to a given parameter in a procedure? Situation:

       

      Parameters: F1, F2, F3, F4

       

      BEGIN

        DECLARE NUMBER VARIABLES.i;

        CREATE LOCAL TEMPORARY TABLE TEST (A STRING);

        WHILE (VARIABLES.i < 5)

        BEGIN

          INSERT INTO TEST (F1|F2|F3|F4); <-- SOMETHING MAGICAL HERE!

          VARIABLES.i = (VARIABLES.i + 1);

        END

        SELECT * FROM TEST;

      END