Saturday, August 28, 2010

hello world for erasme pl/sql-json package

Here's a hello world program for the erasme pl/sql json package.

I need to figure out how to do it outside the context of a dictionary.

    declare
        my_obj    json.JSONStructObj;
        my_tab  json.JSONArray;
    begin

        -- {}
        json.newJSONObj(my_obj);
        json.closeJSONObj(my_obj);
        dbms_output.put_line(json.JSON2String(my_obj));
                           
        -- {'a':'b'}
        json.newJSONObj(my_obj);
        my_obj := json.addAttr(my_obj, 'x', 'hello');
        my_obj := json.addAttr(my_obj, 'y', 99);
        json.closeJSONObj(my_obj);
        dbms_output.put_line(json.JSON2String(my_obj));
    end;

0 comments: