Skip to Main Content

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!

How to get the return variables of WS Json format in GET method

Soukaina IDRISSIFeb 23 2018 — edited Feb 26 2018

Hi everyone,

Following this post How can i get the return variables of GET method in PL/SQL procedure.

In my case, I get result without items like this:

ws_result.png

So doing this code:

l_item_count := apex_json.get_count(p_path => 'items', p_values => l_values);

dbms_output.put_line('Item count: ' || l_item_count);

the value of Item count = 0

Suddently, the looping over all items.

Thank you in advance for help.

This post has been answered by Pavel_p on Feb 24 2018
Jump to Answer

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Mar 26 2018
Added on Feb 23 2018
5 comments
208 views