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：ORA-01455: converting column overflows integer datatype

table: CREATE TABLE STU(ID INT PRIMARY KEY, NAME VARCHAR2(20), AGE INT) INSERT INTO STU VALUES(1, 'ZJW', 24) INSERT INTO STU VALUES(2, 'YGL', 25) INSERT INTO STU VALUES(3, 'ZLY', 24) INSERT INTO STU VALUES(4, 'LBZ', 22) cpp code: int nId; string…
Robin
  • 543
  • 1
  • 6
  • 12
0
votes
1 answer

Trying to run application which uses Oracle libraries on Visual Studio 2005

I am trying to run existing application which uses OCCI libraries - for example in Linker->Input the project has specified oraocci10.lib. I am using Visual Studio 2005. This is what I did. Downloaded 10.2.0.5 package from here(1st and 5th…
anon
0
votes
2 answers

oracle occi connection pool reports ORA-00001: unique constraint (%s.%s) violated error

I tried below code bool Database::initializePool() { connPool_ = env_->createConnectionPool(userName_, password_, connectString_, minConn_, maxConn_, incrConn_); if (!connPool_) return false; else …
Michael
  • 673
  • 2
  • 5
  • 23
0
votes
1 answer

Link errors during Static linking of OCCI/ OCI programs in Oracle 12c

I am trying to develop statically linked OCi/OCCI application and I am getting lots of undefined errors like following. Can somebody tell me which .a libs to be included at link…
Chandu
  • 1,837
  • 7
  • 30
  • 51
0
votes
1 answer

Error: reference to ‘sword’ is ambiguous in armadillo and oracle occi compatibility issue

In armadillo c++ i use some api and using oracle occi try to insert the value into oracle table,but I get some error like this:- /home/oracle/Desktop/project/armadillo-4.450.4/include/armadillo_bits/typedef_elem.hpp:79: error: …
kahsay kalayu
  • 309
  • 5
  • 16
0
votes
0 answers

how to read VARRAY with C++ and OCCI 'execute' method?

i am struggling to read a VARRAY element from oracle 11g database. i am using CPP occi DLL. i can read any other types, and update VARRAY type, but when i try to select VARRAY value, i get an 'access violation' exception in the occi dll :( here is a…
Noam
  • 220
  • 1
  • 2
  • 9
0
votes
0 answers

Oracle OTT error: "String index out of range -11"

I am trying to convert a type into a c++ object using the following command: OTT USERID=VCODER@localhost/153351 INTYPE=T_BODYIN.TPY OUTTYPE=T_BODYOUT.TPY CODE=CPP HFILE=T_BODY.H CPPFILE=T_BODY.CPP MAPFILE=T_BODY.CPPSET This is the content of…
Vcoder
  • 124
  • 1
  • 13
0
votes
1 answer

Getting a VARCHAR2 type column: ORA-01460: unimplemented or unreasonable conversion requested

I have a column of type and size VARCHAR2<50> in my db table. I am using getBlob() method in my CPP code to get the value. I face exception as followed. Exception: ORA-01460: unimplemented or unreasonable conversion requested @ line Blob blob =…
Vijay
  • 55
  • 1
  • 5
0
votes
0 answers

oci.dll for database connectivity

I am using OCCI to connect to oracle database through an already implemented application. This Application lets says "A" already connects to database 1. This implementation is complete Out of the box. Now I am putting some specific code here to…
user2419621
  • 41
  • 1
  • 6
0
votes
1 answer

ora-24399- Invalid number of connections specified -OCCI program

I am using following simple code to connect to database and I am getting error as ORA-24399 which says invalid number of connections specified. I have googled enough but not clue. This is a CPP program. Following is code Snippet: try { …
user2419621
  • 41
  • 1
  • 6
0
votes
3 answers

OCCI app crashes when running in debug mode in Visual Studio 2005

I'm attempting to get a development environment up and running for developing applications with Oracle C++ Call Interface (OCCI) in Visual Studio 2005. My system specs are: OS: Windows 7, 64-bit Oracle: 11g release 11.2.0.2, 32-bit Instant Client:…
Rikke Hamilton
  • 96
  • 1
  • 7
0
votes
1 answer

Oracle OCCI 'select count(*)' result fetching

How can I get there results of the query execution - select count (*) from myTable? The code is: ... oc::Statement* stmt = m_cConnection->createStatement(select count (*) from myTable); oc::ResultSet* res = stmt->executeQuery(); ... How…
Idan Yehuda
  • 524
  • 7
  • 21
0
votes
1 answer

Connecting to oracle database using C programming

I am trying to connect to oracle database using C code. Is it possible to use OCCI in the code? If yes please help me with some examples, please note it has to be C code. If not what are the other options to connect to database using C.
user2419621
  • 41
  • 1
  • 6
0
votes
1 answer

Execute PL/SQL script in C++ using OCCI oracle

I want to run SQL script from a C++ program. my code goes like this: int main() { //..... sql_stmt = "Insert into t1 values ('qwerty');\nInsert into t1 values ('dothar');" "//and many more INSERT statements"; sql_stmt =…
MegaByte
  • 3
  • 3
0
votes
1 answer

how to connect to oracle db using OCCI on linux?

I am trying to connect to oracle database (PHK01200_SECCOMPAS_APPL.WORLD) from linux box (RHEL 6) using OCCI (Oracle instantclient version 12.1 (latest)). I am getting tns error while connection. tnsping works fine though. Could you please help in…
Alok
  • 3,160
  • 3
  • 28
  • 47
1 2 3
…
9
10