BI-TAGS

select regexp_substr

connect by regexp_substr

Unfortunately Oracle have failed to allow the report to be based on a PLSQL function returning the query.

Step1.Create a collection based on a query. The code for this should be placed in a before header process APEX_COLLECTION.CREATE_COLLECTION_FROM_QUERY(p_collection_name => ‘IR_TEST’,p_query => function_returning_query );

Step 2.Create an interactive report querying a collection. Select *From apex_collectionsWhere collection_name = ‘IR_TEST’;

java -jar ords.war configdir /tmp/wls/conf

Configure ORDS by doing: 1java -jar apex.war