Stack Overflow
Stack Overflow

Questions tagged [occi]

Oracle C++ Call Interface (OCCI) is a high-performance and comprehensive API to access the Oracle database.

From the Oracle product page :

Oracle C++ Call Interface (OCCI) is a high-performance and comprehensive API to access the Oracle database. Based on Standard C++ and object-oriented paradigm, OCCI is designed for improved productivity and quality in developing Oracle database applications.

Introduced in Oracle9i, OCCI is being successfully used for client-server, middle-tier, and complex object modeling applications.

149 questions
1
vote
2 answers

How do you compile the occi demo on ubuntu?

It's 2021, does Oracle not support modern operating systems that use compiler ABIs released over 6 years ago? $ make -f demo.mk rm -rf SunWS_cache rm -rf cdemo81 cdemo81.o occidml occidml.o occiobj occiobj.o occiobjo* occiobjm* occiobj.h…
Spongman
  • 9,665
  • 8
  • 39
  • 58
1
vote
1 answer

OCCI - Connecting to a remote database

I'm fairly new to Oracle. I'm trying to connect to a remote Oracle database using OCCI. All the examples i've found up this point have been for connecting to a local database. Could someone please point me in the right direction and let me know…
user399540
  • 269
  • 1
  • 4
  • 7
1
vote
1 answer

OCCI with C++ error: TNS:net service name is incorrectly specified

I have created a simple C++ programm to connect the Oracle OCCI with a OracleDB instance. Here is the Code: #include #include #include // Connection information const std::string userName = "admin"; const std::string…
Skoti23
  • 11
  • 2
1
vote
1 answer

bulk write in an Oracle database with OCCI c++

I am new to oracle database with occi. I want to know how can i insert multiple row at single time with occi in my c++ code? int createStatement(Connection* i_pDBConn) { int retVal = SUCCESS; try { m_pDBStmt…
Piyush Malaviya
  • 31
  • 4
1
vote
2 answers

Converting Oracle's Number toBytes and then to Value + Exponent

I've been looking all around the net for how to convert an Oracle number to something i can use however i've been totally unable to find anybody who has managed to come up with a complete algorithm (particularly with negative exponents). Some…
Christopher Dawes
  • 51
  • 7
1
vote
1 answer

OCCI 19.3.0: createConnection crashes with OCCIUTF16

we would like to upgrade from occi 18 to occi 19.3.0.0.0 because we want to be independent of old MS libraries (MSVCR120.DLL). But there is the following error while connecting the database: "Program: C:\Windows\SYSTEM32\MSVCP140D.dll File:…
Wolfgang
  • 11
  • 1
1
vote
1 answer

Oracle instant client header files are missed

I'm using RedHat OS to build a C++ program that is using OCCI to connect with an Oracle DB. I had to reinstall everything and I found that my make file is adding the header files from the following path /usr/include/oracle/18.3/client64 Which…
Ammar Hussein
  • 5,534
  • 5
  • 18
  • 37
1
vote
1 answer

Connecting c++ program with Oracle using occi library

I'm trying to connect my C++ program to Oracle database(12.1). My C++ program at the moment is (I am using mingw64 g++ compiler in windows): #include void oracle_connect() { using namespace oracle::occi; using namespace…
Eugene
  • 129
  • 2
  • 9
1
vote
0 answers

Linking to OCCI libs generates warnings about std::string

I have created a Static Library project (sll) which is using the std::string. Then I linked it to oraocci12.lib (for release) and oraocci12d.lib (for debug). And just upon linking the static library to the OCCI ones the project generates many…
JKC
  • 109
  • 1
  • 10
1
vote
1 answer

How to set date using OCCI::Date::setDate method

I am trying to create a OCCI::Date object using setDate method but I get an error while doing so. Below is the snippet of my code. using ODate = oracle::occi::Date; ODate ts; ts.setDate(datetime.year(),datetime.month(),datetime.day(),datetime.hour …
user9652780
  • 21
  • 3
1
vote
1 answer

Oracle OCCI - get column by name instead of index

Using oracle OCCI is it possible instead of supplying an index for the column when requesting data from a query resultset, to actually pass the column name and get the data? So instead of doing: (pseudocode) std::string query = "SELECT NAME FROM…
Tony The Lion
  • 61,704
  • 67
  • 242
  • 415
1
vote
0 answers

How to use Direct Path in OCCI?

From the OCCI documentation https://docs.oracle.com/database/121/LNCPP/toc.htm, I cannot find an obvious API to use DirectPath, do I need call OCI api directly in the OCCI application?
zoe
  • 849
  • 6
  • 7
1
vote
2 answers

Connecting c++ program with Oracle

I'm trying to connect my C++ program to Oracle database(12.2). My C++ program is (I am using g++ compiler in ubuntu), #include #include using namespace std; int main() { oracle::occi::Environment *env =…
BSK
  • 61
  • 1
  • 4
1
vote
1 answer

When using OCCI deleting runs forever

the same line: DELETE(SELECT * FROM tablename WHERE id=12) on SQL Developer runs normally and when using the occi API takes forever. I have checked that the query "SELECT * FROM tablename WHERE id=12" matches a non empty sets of rows. More…
jimifiki
  • 5,377
  • 2
  • 34
  • 60
1
vote
2 answers

Exporting an oracle table dynamically to a flat file

I am trying to build a C++ program using occi libraries that will take a select statement or a table name as an input and turn it into a delimited file. However, looking at the documentation, I can't find a way to export all columns of a query…
jawsnnn
  • 314
  • 2
  • 11
1 2
3
…
9 10