No of visitors who read this post: 612
Category: C
Type: Question
Your rating: None Average: 4 (1 vote)

I need to know how to use the Oracle language and the C++ Programming or it is even possible to use them together.

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.

# Comment Id: 50420

 
What you need is a header file named DbManager.h. The iostream.h provide library functions for the input and output stream for use.
#include <DbManager.h>
#include <iostream>
using namespace std;
using namespace oracle::occi;
const string sqlStr("select empname from emp");
const string dateFormat("DD-MON-YYYY HH24:MI:SS");
int main()
 
{
    // Initialize Services
    DbManager* dbm = NULL;
    OracleServices* oras = NULL;
    Statement *stmt = NULL;
    ResultSet *result = NULL;
    try
    {
        dbm = new DbManager(<Enter the username>);
        oras = dbm->getOracleServices();
        Connection * conn = oras->connection();
        stmt = conn->createStatement(sqlStr);
        string empname;
        result= stmt->executeQuery();
        while (result->next()){
            empname = result->getString(1);  // get the name
            if (result->isNull(1)){
                cout << "No Employee”;
            }
           cout << empname;
        }
        stmt->closeResultSet(result);
        conn->terminateStatement(stmt);
        delete dbm;
    }
    catch (SQLException& ex)
    {
        if (dbm != NULL)
        {
            dbm->rollbackActions(ex, stmt, result);
       }
    }
    catch (ExoException& ex2)
    {
        cerr << "\nGot Exception:\n" << ex2.getExceptionText() << endl;
        exit(1);
    }
   
    return 1;
}