Questions tagged [oracle-call-interface]

OCI is the Oracle Call Interface, used for direct programming access to an Oracle Database. Similar to ODBC, it is specific to Oracle databases.

The Oracle Call Interface (OCI) is a C language programmatic interface specific to Oracle databases. The API is database version agnostic, meaning programs written using the OCI API against Oracle version 8, will continue to function correctly against version 11gR2.

It is used over generic interfaces like ODCB because it allows access to Oracle database specific features like connection pooling, security access, and data types.

648 questions
61
votes
8 answers

libaio.so.1: cannot open shared object file

I have a simple test program that when I run I get: ./hello: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory I link it like this: $(CC) $(CCFLAGS) -o hello hello.o…
wytten
  • 2,800
  • 1
  • 21
  • 38
46
votes
1 answer

Rails NoMethodError: undefined method new for BigDecimal:Class

My app is on: ruby-2.6.4 Rails 4.2.8 activerecord-4.2.8 I'm upgrading a rails app to ruby-2.6.4 When running a rake task in development, for testing, I am getting errors for BigDecimal() and…
John Cowan
  • 1,452
  • 5
  • 25
  • 39
39
votes
11 answers

How to find out when an Oracle table was updated the last time

Can I find out when the last INSERT, UPDATE or DELETE statement was performed on a table in an Oracle database and if so, how? A little background: The Oracle version is 10g. I have a batch application that runs regularly, reads data from a single…
Maximilian
  • 4,728
  • 5
  • 29
  • 28
19
votes
2 answers

Oracle thin driver vs. OCI driver. Pros and Cons?

When you develop a Java application that talks to oracle DBs, there are 2 options right? One is oracle thin driver, and the other is OCI driver that requires its own installation (please correct if I'm misunderstanding). Now, what are the pros and…
Enno Shioji
  • 26,542
  • 13
  • 70
  • 109
14
votes
4 answers

docker: Error response from daemon: OCI runtime create failed: unable to retrieve OCI runtime error

my docker starts giving error after a recent update. Existing containers works but I can not build or run any image. A simple docker run hello-world gives me an error: docker: Error response from daemon: OCI runtime create failed: unable to…
amina mollaysa
  • 387
  • 2
  • 4
  • 18
13
votes
4 answers

INSERT of 10 million queries under 10 minutes in Oracle?

I am working on a file loader program. The purpose of this program is to take an input file, do some conversions on its data and then upload the data into the database of Oracle. The problem that I am facing is that I need to optimize the insertion…
badola
  • 820
  • 1
  • 13
  • 26
13
votes
2 answers

Oracle Pro*C/OCI install handlers for SIGSEGV/SIGABRT and friends - why, and how to disable?

When using Pro*C (a embedded SQL preprocessor from Oracle for C-Code) or OCI I noticed that the connect/init routine installs some signal handlers. That means before a EXEC SQL CONNECT :username IDENTIFIED BY :password USING :dbspec ; or…
maxschlepzig
  • 35,645
  • 14
  • 145
  • 182
11
votes
3 answers

Oracle OCI, bind variables, and queries like ID IN (1, 2, 3)

Succinct Version: I'm looking for a C++ OCI adaptation of the following Java technique, where code is able to bind an array of numbers (the array size can vary) into a non-PL/SQL SELECT statement and then use the resulting array in a WHERE ID IN…
StilesCrisis
  • 15,972
  • 4
  • 39
  • 62
10
votes
1 answer

Suppress PHP warnings for expected Oracle exceptions

I have a PHP function that calls a PL/SQL package that can throw a number of known exceptions (i.e. user exceptions) that I can catch in PHP and act on. The problem is, despite catching the exception in PHP I get a warning in the PHP log file with a…
Stephen
  • 103
  • 1
  • 4
10
votes
2 answers

Oracle OCI and Thin drivers are missing in SQuirreL SQL

I downloaded SQuirreL SQL and I want to use it as an Oracle client, but when I go to Drivers tab, the following jars are missing: Oracle OCI Driver Oracle Thin Driver How can I fix this problem?
ROMANIA_engineer
  • 54,432
  • 29
  • 203
  • 199
10
votes
3 answers

Oracle, PDO_OCI vs OCI8

The company I work for currently uses some basic functions to abstract the OCI libraries as a means for DB connectivity. We're considering switching to PHP's PDO object, but from some quick searches, it looks like the Oracle driver is a bit less…
jarcoal
  • 1,445
  • 2
  • 16
  • 19
9
votes
2 answers

Connection was reset when I try to execute a query in the yii framework

When I try to connect to my database, everything is ok, but when I try to use the query() command to execute a SQL statement I get this error: The connection was reset The connection to the server was reset while the page was The page doesn't…
Fabio Cardoso
  • 1,181
  • 1
  • 14
  • 37
9
votes
2 answers

Call to undefined function oci_connect, php_oci8_12c.dll, windows 8.1, php5.6.6

I have a simple php script: When I run it (from a browser or from the command line), I get the error: Call to…
Graham
  • 7,807
  • 20
  • 69
  • 114
8
votes
1 answer

Does Oracle provide public Symbol Files (PDB) for OCCI/OCI?

OTN Thread: Does Oracle provide public Symbol Files (PDB) for OCCI/OCI ? When debugging an application under Windows (with Visual Studio or WinDBG) that makes use of OC[C]I it would often be convenient if there be symbol files (PDB files) for the…
Martin Ba
  • 37,187
  • 33
  • 183
  • 337
8
votes
3 answers

SQLSTATE[HY000]: OCISessionBegin: ORA-21561: OID generation failed

I'm receiving the following error when trying to do a PDO OCI SQL query on one of my web servers: SQLSTATE[HY000]: OCISessionBegin: ORA-21561: OID generation failed I've confirmed that the Oracle server is accessible from the machine and network…
Camden S.
  • 2,185
  • 1
  • 22
  • 27
1
2 3
43 44