Are there any Oracle Stored Procedure Accessor Generators for C++?

Question

I've been spending more and more time writing DB Wrappers for Oracle access. This seems to be quite generic procedure, and I was wondering is there already are code generators that generate access routes to Oracle PL/SQL Stored Procedures in C++?

I'm looking for a configurable generation tool that would be capable of managing connection and handle multiple threads if needed. I'm aware of OCI/OCCI and Oracle C++ extension, but I'm looking for a pure self-contained C++ accessor generation tool.

Any advice welcome.

Thank You!

Answer 1

We use the SQLAPI (http://www.sqlapi.com/) for all of our C++ development w/ Oracle. It I think is a more efficient wrapper for the OCI (though as another person pointed out, the OCCI is prety good). Another advantage for the SQLAPI is that it also supports other database platforms. We use it for MySQL as well and having that abstraction layer in between our application and database layers certainly simplifies things quite a bit.

Answer 2

You might also want to have a look at:

• http://orclib.sourceforge.net
• http://otl.sourceforge.net/
• http://www.codeguru.com/cpp/data/mfc_database/oracle/article.php/c4305

Answer 3

You may want to take a look at C++ ORM tools that support "view" objects which can be used to "receive" stored procedure results. Something like ODB.