Oracle Extended Stored Procedure with C++

Question

I am currently adding Oracle 10.2.0. as a viable database to a product. The product originally allows connection to SQL Server and I have found some extended stored procedures.

Is it possible to produce similar extended stored procedures for Oracle with C++?

If so, how do I accomplish this? Example code would be much appreciated.

Answer 1

You will need to use Oracle External Procedures.

Here is a discussion on getting the environment set up properly - it's tricky.

Asktom.com has an interesting discussion.

Be aware there are several security issues to be concerned with.