Search code examples
oracleplsqlpljson

How to convert JSON object to varchar2 using PL/JSON

I need to convert json object to varchar using PL/JSON library. For an example,

declare
mapData     json;
text        varchar2(20)
begin

json := 'json object';
text := convert_to_varchar(json);
end;
Solution

  • Assuming you know that your JSON will fit into a varchar2:

    text := mapData.to_char();

    This method is clearly defined in the JSON type declaration -- https://github.com/pljson/pljson/blob/master/src/json.typ#L56