Hi,I wanted to create a simple JSON clob like -{ "attribute1": "value1", "attribute2": "value2", "attribute3": "value3"}I am using PLSQLAP_Document_API to create this type of data. But the problem is, during initialization of the PLSQLAP Document, I have to give a name. And that name becomes a parent attribute for rest of my attributes and the output is like -{ "MAIN_DOC": { "attribute1": "value1", "attribute2": "value2", "attribute3": "value3" }}I can’t get rid of this “MAIN_DOC” attribute. Is there something I am doing wrong?Below is my snippet -DECLARE json_doc_ PLSQLAP_Document_API.Document := PLSQLAP_Document_API.New_Document('MAIN_DOC'); json_ CLOB;BEGIN PLSQLAP_Document_API.Add_Attribute(json_doc_, 'attribute1', "value1"); PLSQLAP_Document_API.Add_Attribute(json_doc_, 'attribute2', "value2"); PLSQLAP_Document_API.Add_Attribute(json_doc_, 'attribute3', "value3"); PLSQLAP_Document_API.To_Json(json_ => json_,
Already have an account? Login
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.