Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win


connectivity between c++ and oracle database

Posted on 2002-04-30
Medium Priority
Last Modified: 2012-05-04
how to connect oracle database through c++ programming.........want some sample code........
Question by:akmak
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
LVL 32

Expert Comment

ID: 6982102
Oracle has available a developers toolkit if you want to make a "native" interface from C++ to Oracle.  

But most developers choose to use the Oracle ODBC driver.

Check with your Oracle sales rep. for the developer product.

You probably got the ODBC driver with your Oracle software.

Accepted Solution

zebada earned 200 total points
ID: 6982712

Expert Comment

ID: 6983478
Depending on what you're trying to do, there are simpler options than OCI.  The Pro C/C++ precompiler is an option that lets you embed SQL in your code, then run it through a program Oracle provides that creates all the OCI code necessary to retrieve that data from the database.

There are also a few OCI wrappers that greatly simplify the task of accessing the database for your typical data retrievals.  Three of them are found at the bottom of this page: http://www.orafaq.com/faqoci.htm.

I recently switched from using straight OCI to the Oracle Template Library (OTL) package mentioned.  I've found it to greatly simplify your typical database accesses.  The page includes docs and over a hundred examples.  

Depending on exactly what you're trying to do, give one of these libraries a try.
LVL 11

Expert Comment

ID: 7122236
Dear akmak

I think you forgot this question. I will ask Community Support to close it unless you finalize it within 7 days. You can always request to keep this question open. But remember, experts can only help you if you provide feedback to their questions.
Unless there is objection or further activity,  I will suggest to accept


comment(s) as an answer.

If you think your question was not answered at all, you can explain here why you want to do this and post a request in Community support (please include this link) to refund your points. The link to the Community Support area is: http://www.experts-exchange.com/commspt/


Expert Comment

ID: 7138146
Force accepted

** Mindphaser - Community Support Moderator **

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Article by: SunnyDark
This article's goal is to present you with an easy to use XML wrapper for C++ and also present some interesting techniques that you might use with MS C++. The reason I built this class is to ease the pain of using XML files with C++, since there is…
Introduction This article is the first in a series of articles about the C/C++ Visual Studio Express debugger.  It provides a quick start guide in using the debugger. Part 2 focuses on additional topics in breakpoints.  Lastly, Part 3 focuses on th…
The goal of the video will be to teach the user the difference and consequence of passing data by value vs passing data by reference in C++. An example of passing data by value as well as an example of passing data by reference will be be given. Bot…
The viewer will learn additional member functions of the vector class. Specifically, the capacity and swap member functions will be introduced.
Suggested Courses

618 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question