1 Reply Latest reply on Dec 17, 2014 9:59 AM by Dwhittin-Oracle

    how to use complex data types in pl/sql UNIT TEST CASES

    user4597341
    user4597341 Dec 14, 2014 4:38 PM

      Hi,

      I am not seeing any support for complex data types like VARRAY, NESTED TABLES, ASSOCIATIVE ARRAYs in PL/SQL unit test cases.

      using variable substitution i want to read the VARRAY which is registered as OUT parameter of my SP.

      When i am using {p_array}.. it is giving error.

      can i get any example on how to use variable substitution for these complex types.

      • 621 Views
      • Tags:
        • 1. Re: how to use complex data types in pl/sql UNIT TEST CASES
          Dwhittin-Oracle
          Dwhittin-Oracle Dec 17, 2014 9:59 AM (in response to user4597341)

          That type of substitution supports only basic types (VARCHAR,NUMBER, etc). I will raise an enhancement request for consideration in a future release to look at providing a more encompassing binding method.

           

          So, as it is, your best available approach is to use static value comparison bearing in mind this is a Unit Testing feature, not a System Testing one.

           

          BTW: This is of no help in this situation but I believe a OUT parameter substitution system is {param$}