Pl/SQL json list loop

Question

How can I retrieve content from below json by using pl/sql json from http://sourceforge.net/projects/pljson/?

{"errors":["Invalid weight","Invalid pallet spots"]}

I want to get text like this 1. Invalid weight, 2. Invalid pallet spots.

Thanks

doberkofler · Accepted Answer · 2013-10-05 13:06:47Z

1

This is actually quite simple:

DECLARE
    obj json := json();
    arr json_list := json_list();
BEGIN
    obj := json('{"errors":["Invalid weight","Invalid pallet spots"]}');
    arr := json_list(obj.get('errors'));

    dbms_output.put_line(arr.get(1).get_string());
    dbms_output.put_line(arr.get(2).get_string());
END;
/

You might also want to have a look at my own (performance optimized) version of a json library for PL/SQL @ https://github.com/doberkofler/PLSQL-JSON

answered Oct 5, 2013 at 13:06

doberkofler

10.5k26 gold badges92 silver badges150 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Mariah Over a year ago

Hello @materialdreams, your work its useful 2 me, thanks a lot!

Collectives™ on Stack Overflow

Pl/SQL json list loop

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related