I want to use as input an complex collection, and this collection has to be integrated. Is possible to create a dynamic collection using select’s and variables, and test a lot of combinations?
And example of my collection (INFO_LIST):
CREATE OR REPLACE TYPE “T_STREET” as object (
CREATE OR REPLACE TYPE “STREET_LIST” as table of T_STREET
create or replace type T_INFO as object (
CREATE OR REPLACE TYPE “INFO_LIST” as table of T_INFO
I’m assuming that you know about possibility to define collection items statically?
If I understand correctly, you want to define an input value as a SELECT that is returning your collection of T_INFO instances?
If that’s correct, when (where) you would define what are the appropriate outcome values? By the way, what should be outcome data type(s)?