CODEWITHSUNDEEP
jsonplsqloracle11goracle-apexpljson
ans240577
ans240577

Reputation: 1

Json strings stored in collection in oracle apex classic report using pljson

I have used the following query for the classic report using pljson: the page works, but it only shows 46 records, in all cases. Does anyone know why this limitation, or have you had a similar experience? Thanks for your help

select * from table(pljson_table.json_table((select clob001 from apex_collections 
    where collection_name = 'P204_DOREST_RESULTS'),

    pljson_varray('items[*].conceptId',
          'items[*].effectiveTime',
          'items[*].fsn.term',
          'items[*].pt.term'),
    pljson_varray('conceptId',
          'effectiveTime',
          'term',
          'termi'),

table_mode => 'nested'
));

Upvotes: 0

Views: 313

Answers (0)

Related Questions