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
0
votes
1 answer

OCCI linkage: Undefined symbols

I have been working in a solution with Oracle database access and C/C++. I'm using OCCI but we are in trouble to link in Solaris 11. Solution works "like a charm" in Linux (OpenSUSE and Mint), but doesn't in Solaris 11. Here environment…
filosofisto
  • 105
  • 7
0
votes
1 answer

how to fetch all rows when using array fetch by setdatabuffer()

i'am blocked the problem how to fetch all row, that is last left rows when using array fetch by setdatabuffer(). there's 80405 rows in a table named example. OcciResultSet resultSet = occi.executeQuery("select x, y from example"); const int size…
ruuut
  • 9
  • 1
0
votes
1 answer

OCCI - setDataBuffer + vector

Trying to minimize amount of lines for an OCCI array fetch by storing a struct containing a char buffer into a vector, code below: struct Columns { char buffer[1000][300]; }; int i = 1; Columns col; ub4* ub = NULL; …
user1324674
  • 384
  • 1
  • 3
  • 12
0
votes
0 answers

Compiling OCCI under Windows

ALL, On Windows it is really bad idea to link Debug and Release version of different libraries/binaries as this could cause the crash. The problem is that Windows CRT is different for the Debug and Release. I'm developing program that will connect…
Igor
  • 5,620
  • 11
  • 51
  • 103
0
votes
1 answer

Oracle OCCI setDataBuffer causing ORA-01406: fetched column value was truncated

I am using setDataBuffer to retrieve the rows returned from a stored procedure through a cursor as setPrefetchRowCount does not seem to work in this case. Using setDataBuffer works well when the buffer is greater than the total number of returned…
user2672165
  • 2,986
  • 19
  • 27
0
votes
1 answer

OCCI resultset getString() method returning nullpointer error

I'm getting the below error when trying to fetch a string value from a column in the current row ( rs->getString(2) ): Unhandled exception at 0x61d4336f (msvcp100d.dll) in OCCITest.exe: 0xC0000005: Access violation reading location…
Spigy
  • 41
  • 1
  • 8
0
votes
1 answer

invalid pointer error in OCCI application

I am using the code from this tutorial to experiment with OCCI: http://oradim.blogspot.com.br/2009/08/getting-started-with-occi-linux-version_16.html When I try to run the application, it gives me the following error: *** Error in `./occi_test':…
user90210
  • 1
  • 3
0
votes
1 answer

Building occi plugin for node-mapnik

I'm trying to build occi plugin for node-mapnik. My purpose is to use that plugin in the node-mapnik installation of tilelive-bridge node module. Here's what I did first: git clone https://github.com/mapnik/mapnik --depth 5 cd mapnik git submodule…
ardilgulez
  • 1,856
  • 18
  • 19
0
votes
1 answer

ORA-00947: not enough values when creating object in Oracle

I created a new TYPE in Oracle in order to have parity between my table and a local c++ object (I am using OCCI interface for C++). In the code I use void insertRowInTable () { string sqlStmt = "INSERT INTO MY_TABLE_T VALUES (:x)"; try{ …
cateof
  • 6,608
  • 25
  • 79
  • 153
0
votes
1 answer

oracle occi ResultSet::next() core dump

#0 0x0000003d7e432925 in raise () from /lib64/libc.so.6 #1 0x0000003d7e43408d in abort () from /lib64/libc.so.6 #2 0x00007ff601e3ba55 in os::abort(bool) () from /usr/java/jdk1.7.0_67-cloudera/jre/lib/amd64/server/libjvm.so #3 …
romancegirls
  • 11
0
votes
1 answer

ld cannot find OCCI libraries even if they exist in LD_LIBRARY_PATH

I am just doing some simple OCCI thing, however it compiles a bit strangely Environment: Oracle VM: Centos7 64bit on Windows 8 64bit gcc-c++.x86_64 Simply installed Oracle XE by double clicking the rpm (download pages says linux 64bit) echo…
Jimmy Chi Kin Chau
  • 153
  • 1
  • 13
0
votes
1 answer

VS2012 Returning vector of Oracle unique_ptr´s crash

I do have a code structure where I read Oracle rows from database and I do assign then to a common model that represents its data (called commonmodel::Model). I´m using VS2012 on Windows 7. My issue is with this piece of code below, where I do…
Mendes
  • 17,489
  • 35
  • 150
  • 263
0
votes
0 answers

OCCI C++ app undefined reference

I started here but so much has changed I thought it best to start a new question, especially since I think the CMake issue in the that question is solved. Background I'm trying setup a basic shell of a project that involves connecting a C++ midtier…
Malachi
  • 133
  • 10
0
votes
1 answer

Oracle get last inserted row id using OCCI and C++

Given the code above, how can I grab the ID of the row inserted into database. I´m using C++ and oracle OCCI interface: std::stringstream sqlStream(""); sqlStream << "INSERT INTO MYTABLE (COL1, COL2, COL3) VALUES (1, 2, 3) RETURNING ID INTO…
Mendes
  • 17,489
  • 35
  • 150
  • 263
0
votes
0 answers

Can we connect to Oracle database from Unix system without OCCI?

Can we connect to Oracle database from Unix system without OCCI? Is it necessary for a Instant Client to be installed to use the Database connection? Kindly give suggestions. Thanks
Vidyasagar S T G M
  • 1
  • 5
1 2 3
…
9 10