Toad World® Forums

Is possible to input a dynamic collection on my test case?


#1

Hi everybody,
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?
Thanks
And example of my collection (INFO_LIST):
CREATE OR REPLACE TYPE “T_STREET” as object (
id_city number(8),
id_street number(8),
id_zip_code varchar2(10),
id_package varchar2(24),
dt_package date,
)
/
CREATE OR REPLACE TYPE “STREET_LIST” as table of T_STREET
/
create or replace type T_INFO as object (
id number(8),
id_city number(8),
hash_package varchar2(200),
streets street_list
)
/
CREATE OR REPLACE TYPE “INFO_LIST” as table of T_INFO
/


#2

Hi,

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)?

Best regards,

Ferdinand