I have a use case which requires to import a data stream from message queue into oracle database,
the data stream is essentially a bunch of JSON objects which are to be transformed and then imported into different tables.
I wonder if there is a way better than Oracle Call Interface or ODBC.
If not, I'd like to know the performance difference between OCI and ODBC when it's only simple inserts/updates in the SQL statements.
--- The advantages of OCI described here OCI: Introduction and Upgrading is not quite informative for me to compare it with ODBC for my use case.