Stack Overflow
Stack Overflow

Questions tagged [oci8]

OCI8 is the driver used to connect various programming languages to an Oracle database

OCI8 (Oracle Instant Client) is the open source C library used to facilitate connections with all Oracle databases at or above version 9.2.

Many programming languages offer a compiled version of this

PHP

Available via PECL(also offers the Windows DLL). Some Linux package manager libraries (like remi for Enterprise Linux(RHEL, CentOS)) also offer a pre-compiled version.

Ruby

Can be compiled, although some projects offer gems

374 questions
5
votes
5 answers

Dealing with eacute and other special characters using Oracle, PHP and Oci8

Hi I am trying to store names into an Oracle database and fetch them back using PHP and oci8. However, if I insert the é directly into the Oracle database and use oci8 to fetch it back I just receive an e Do I have to encode all special characters…
drenocartero
  • 4,941
  • 7
  • 26
  • 26
4
votes
0 answers

Installing oci8 driver: (pecl install oci8) Oracle Instant Client SDK header files not found (Mac OSX High Sierra)

I need to install the oci8 driver for MacOSX (High Sierra). However, whenever I run the command pecl install oci8, I get asked. Please provide the path to the ORACLE_HOME directory. Use 'instantclient,/path/to/instant/client/lib' if you're…
user11150354
4
votes
2 answers

PHP Startup: Unable to load dynamic library 'C:\xampp\php\ext\php_oci8_12c.dll' - The specified procedure could not be found

we face a big problem to connect oracle server in php What i done Setp 1: Install Windows 7 32bit Step 2 : install XAMPP 32 ( Includes: Apache 2.4.29, PHP 7.1.11, phpMyAdmin 4.7.4, OpenSSL 1.0.2, XAMPP Control Panel 3.2.2) Step : Instant…
Md Hasibur Rahaman
  • 1,041
  • 3
  • 11
  • 34
4
votes
1 answer

Trying to build static CGO executable with oracle libraries on Linux/Ubuntu

I have already searched for some days, tried several suggestions but none helped. At the moment I just want to create a small Go snippet which connects to an Oracle Database. While everything works by using normal go build and invoking the resulting…
hanneslehmann
  • 133
  • 10
4
votes
4 answers

Compile PHP OCI8 extension under Alpinelinux

I'm trying to compile PHP OCI8 extension and run it under Alpinelinux. But it seems extension has some dependencies on symbols defined in glibc but missing in musl libc. Is there any existent compiled PHP OCI8 extension I can use? Or is there any…
Sergey Kolodyazhnyy
  • 691
  • 5
  • 17
4
votes
1 answer

ruby OCI8 slow initialization

I'm developing API for product based on Oracle database and I tried to use ruby-oci8 gem, but I faced a strange problem - OCI8.new is very slow, it takes 1,2-1,5 second to connect to database. For example: ~ mmulev$ irb 2.1.1 :001 > require 'oci8' …
Mike Mulev
  • 76
  • 7
4
votes
2 answers

php-oci8 encoding issue

Similar questions have been asked, but the regular solutions do not work for me. Probably I am missing something. I am about to loose my mind :((( As you can understand it from the title, I have an oracle database with non-ascii content. I want to…
Ramazan
  • 989
  • 3
  • 14
  • 26
4
votes
1 answer

How to open custom type from plsql on php?

I have created a type on Oracle CREATE OR REPLACE TYPE myType as object ( id number,rol varchar(16) );​ Then I have this function that returns an object of type myType create or replace FUNCTION myFunction(...) RETURN myType IS .... END; On…
Hohenheimsenberg
  • 935
  • 10
  • 25
3
votes
1 answer

ActiveRecord oracle_enhanced adapter could not load ruby-oci8 library

rails g scaffold failed, but oci script and irb data query worked. Couldn't figure out what went wrong. rails g scaffold table field1:integer field2:string .... invoke …
benjwlee
  • 31
  • 1
  • 3
3
votes
1 answer

Azure Web App, PHP 7.4, OCI8 (Oracle Instant Client 12.2.0.1.0)

We're trying to lift an existing PHP 7.4 app from an internal server running on Windows Server 2012 to an Azure Web App. The PHP app uses OCI8 to connect to an Oracle database. Everything (except the database connection) works fine without the OCI8…
user1874135
  • 419
  • 5
  • 17
3
votes
1 answer

Output from gem's native extension for debugging purposes

While using a gem, I've encountered problem in native extension (which is part of the gem) that I wanted to debug. I tried adding printing methods in C code, but nothing displays when using a gem. I've tried using various printing C functions…
Miron Marczuk
  • 81
  • 1
  • 7
3
votes
0 answers

How to statically link external Go libraries

I have a small application written in Golang which uses Oci8 for Oracle database connectivity. When I attempt to run the binary built on my Macbook on another Macbook (same OS version), it fails with the following error: dyld: Library not loaded:…
rjni
  • 471
  • 7
  • 7
3
votes
0 answers

ORACLE 11g DB Response slow with CAKEPHP on AMAZON

We have a Cakephp 1.3 application that is connected with ORACLE 11g Database , First it was hosted on our in house server there was no problem , but as we moved to AWS , database is giving slow response some time , some time it is very fast…
Ayush Pant
  • 392
  • 4
  • 17
3
votes
3 answers

php oci8 module not loaded (ubuntu 16)

I have a problem with the oci8 module, it doesn't load. The OS is Ubuntu 16, with Apache 2.4 and PHP 5.6 I do the following steps: I Downloaded Oracle Instant Client Basic and SDK packages: (…
Ahmad Abdullah
  • 1,645
  • 1
  • 16
  • 25
3
votes
3 answers

Php and oracle OCI query

I have a prolem with this code $stmt = oci_parse($db, $sql); $isQueryOk = oci_execute($stmt); if ($isQueryOk) { while (($row = oci_fetch_assoc($stmt)) != false) { array_push($results, $row); } echo json_encode($results); } else…
Leonel Matias Domingos
  • 1,922
  • 5
  • 29
  • 53
1
2
3
…
24 25