Hi NAgesh, Can you send us the sample code how to extract data from Json from SQL. I've a requirement is Input data coming as CLOB in to Oracle Standalon Function We have written PAcakge.Function to accept input (JSON) as CLOB. I want to read data from CLOB which is JSON file in to custom table. Can you please help me . Thanks, Neel