Download and install PL/JSON.
Following is an example of how to parse a JSON array represented as string:
declare
my_clob clob := '[| var AWS = require('aws-sdk'); | |
| AWS.config.update({ region: 'us-east-1' }); | |
| var s3 = new AWS.S3(); | |
| var obj = { | |
| firstname: "Navjot", | |
| lastname: "Dhanawat" | |
| }; | |
| var buf = Buffer.from(JSON.stringify(obj)); |
Download and install PL/JSON.
Following is an example of how to parse a JSON array represented as string:
declare
my_clob clob := '[