Trying to create APEX Collection from query with bind variable (problem)
I'm trying to create a Collection in a Page Process via PL/SQL. Here's a simplified version of the code...
APEX_COLLECTION.CREATE_COLLECTION_FROM_QUERY (
p_collection_name => 'VTERM',
p_query => 'select * from stvterm where stvterm_code = :P8_TERM');
This yields the error ORA-1008-not all variables bound. Is there an easy fix? If not, what might be a work-around? I have tried putting the create collection statements in a procedure, but when invoked the process just hangs.
Thanks.