0 Replies Latest reply on Dec 11, 2014 1:46 PM by user4597341

    Subsitution variables {$} not working for VARRAY and STRUCT when writing PL/SQL test cases

    user4597341

      we are writing unit test case for a procedure which has OUT as VARRAY.

      In the Result column is it shown as 'varchar2()' and we are not able to change

      its value.

      In the process validation phase we thought of writing custom PL/SQL code which

      can iterate through the OUT varray and we can raise exception if specific value is not there.

      so we thought of using variable substitution approach like {P_ARRAY$} but

      it was throwing error.We surrounded it with string literal like

      '{P_ARRAY$}' and then we found that we got values like

      'varchar2(1,2,3,4)'.

      now question is now to use substitution variables for VARRAY and STRUCT.