We need to call Oracle stored procedure from Apigee proxy. First I explored node.js option. However there is no node.js based Volos SQL connectors (http://docs.apigee.com/api-services/content/apigee-connectors) are available for oracle database. The connectors are available only for MySql, Postgres and SQL server. There is node.js module (https://www.npmjs.com/package/oracledb) from oracle but it required additional prerequisites Python, oracle client, C Compiler with support for C++ 11 etc which is not possible in our case.
So the next approach is to use java call out policy. We can call oracle procedure in java program and use java call out policy. For this no additional software's are required except jdbc driver. I assume it should work.
Is there any other alternative where we can connect to oracle database?