APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Create collection from query - Bind variables

partlycloudyOct 3 2018 — edited Oct 4 2018

The apex_collection.create_collection_from_query_b2 API offers the option to use bind variables in the query. The p_names/p_values parameters require apex_application_global.vc_arr2. In prior releases, we used apex_util.string_to_table to pass in delimited name/value pairs but this is now marked as deprecated.

I thought apex_string.split would be a drop-in replacement for apex_util.string_to_table but the SPLIT procedure returns apex_t_varchar2 so that doesn't work.

Any ideas? Should a CAST function be used to translate between the object type and PL/SQL table type?

This post has been answered by fac586 on Oct 3 2018

Jump to Answer

Added on Oct 3 2018

#apex-discussions

7 comments

1,047 views