Sahithi,

Sure you can pass the JSON to your Virtual Procedure. You can either pass this as "string" or clob. In the procedure, you can use JSONPARSE function to parse the content, then use JSONTOXML function to convert the content to XML, then use can extract the data using the XPATHVALUE Function. For example:

select XPATHVALUE(JSONTOXML('person', jsonParse('{"Customer":{"CustomerId":88, "CustomerName":"Wellington Importadora"}}', true)), '/person/Customer/CustomerId')

should return 88. In the procedure, you would do

jsonTxt = ..
xml xmlValue = JSONTOXML('root', JSONPARSE(jsonText));
value = XPATHVALUE(xmlValue, 'your-xpath-expr')

HTH

Ramesh..