4

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!

Leonid
  • 22,360
  • 25
  • 67
  • 91
  • Related: http://stackoverflow.com/q/74141/203968 – oluies Oct 09 '10 at 20:08
  • OCCI is pretty good. I use it for a long time and it's really nice. It's tested on lots of servers, it's very fast and gives you much opportunities. I'd recommend that :) Also, the support is pretty good. – Kiril Kirov Oct 09 '10 at 20:27
  • I'm specifically looking for a tool to generate accessors for PL/SQL procedures based on their headers and type information. – Leonid Oct 09 '10 at 22:41

2 Answers2

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.

Dave LeJeune
  • 407
  • 5
  • 13
1

You might also want to have a look at:

doberkofler
  • 9,511
  • 18
  • 74
  • 126