Support for Oracle collection types

[benilovj]

An example:

TYPE serv_tab IS TABLE OF services.service_id%TYPE INDEX BY BINARY_INTEGER;
PROCEDURE CreateOrder(Customer IN NUMBER,
                          ParentID IN VARCHAR2,
                          RelatedID IN db_order.serv_tab);

Another example: https://gist.github.com/benilovj/5299071

[benilovj]

@javornikolov do you have experience with this data type?

[javornikolov]

Quite rarely but outside of JDBC. In general it allows you to fit a table into a table column. I wonder how such a test could be described on top of fitnesse page - since it's not simple 2-D table any more. We're getting multi-dimensional.

[javornikolov]

Maybe something similar to "store query" can be used to define a variable of collection type. And the this can be used in query/insert/etc. fixtures

[javornikolov]

Here is some docs from Oracle on the topic how to work with these collection types via JDBC: http://docs.oracle.com/cd/E11882_01/java.112/e16548/oraarr.htm

[javornikolov]

Some scattered notes:

• It would be good if we come with some ideas of notation how to express these tests in DbFit. How would we be filling in input data for collections; or expectations of collection results would be welcome.
• I'm wondering about some workarounds: if you can define a function returning collection - it can be wrapped in a query like SELECT ... FROM TABLE( your_function ). And it will be simple query /can be used in DbFit like normal query/.
• Examine existing functionality for REF CURSOR and for store query