Thanks for the reply. I have infact downloaded pLJSON and applied in my database.
Referred to various examples given here that talk on reading a small data in JSON format, printing to DBMS_OUtput etc.
what Iam looking for, is a code that can read a JSON file using plsql API to a oracle table. Any small sample code snippet should be helpful for me to build on