Answer the question
In order to leave comments, you need to log in
How to access an element of a collection through a variable?
I have a nested collection:
TYPE film_link_record IS RECORD ( code NUMBER
, groupid NUMBER
, catid NUMBER);
TYPE film_link_tbl IS TABLE OF film_link_record
INDEX BY PLS_INTEGER;
TYPE cinema_link_tbl IS TABLE OF film_link_tbl
INDEX BY PLS_INTEGER;
cinema_data cinema_link_tbl;
Cinema_data(CinemaID)(FilmPackID).code
get_data(code);
get_data(groupid);
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question