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
3
votes
2 answers

php7, references and oci_bind_by_name

I'm posting this here before php.net to maybe get a better understanding of the difference in behavior that I'm seeing between PHP 5.x and 7.x. The following code works in PHP 5.x but not 7.x $conn = oci_connect('****', '****', '****',…
dkw
  • 63
  • 4
3
votes
0 answers

Can't read Varray/Nested table and custom types in PHP (Codeigniter)

Each time i try to do a select query for a field with a custom type/nested table like this: create or replace type phone_list_type as VARRAY(3) of varchar(30); create or replace type Email_list_type as VARRAY(3) of varchar(30); Table Users: create…
Ribeiro
  • 364
  • 1
  • 3
  • 12
3
votes
1 answer

Ruby gem 'ruby oci8' returning Error: 'OCI.DLL: 126(The specified module could not be found. ) (LoadError)'

My platform: - Ruby 2.2.2p95 (2015-04-13 revision 50295) [x64-mingw32] - Windows 7 64bit I have install Oracle Instant client i.e. the following: Oracle SDK Oracle SQLPLUS Oracle windows (I have the user variable path pointing to when Oracle…
Irvz
  • 31
  • 1
  • 2
3
votes
2 answers

Get last inserted id (go + oracle)

I need to insert two records in Oracle database from my go application using sqlx (https://github.com/jmoiron/sqlx) with go-oci8 (https://github.com/mattn/go-oci8) driver. Second record references previous one by foreign key. So I need to have…
Sergey Melekhin
  • 109
  • 1
  • 8
3
votes
4 answers

can not load oci8 -> Fatal error: Call to undefined function oci_connect()

I want to connect to my oracle database, but i have a problem with function oci_connect. i have tried to uncomment this: extension=php_oci8.dll but, still have an error : Fatal error: Call to undefined function oci_connect() in…
allrise
  • 31
  • 1
  • 1
  • 2
3
votes
1 answer

can not connect to oracle database using PHP 5.6.14 - OCI Connect issue

i want to connect into my oracle database, i use xampp 5.6.14, i already uncomment the extension : extension=php_oci8_11g.dll ; Use with Oracle 11gR2 Instant Client when i check in php.ini file, it's only have extension ;extension=php_oci8.dll ;…
jewel
  • 41
  • 1
  • 4
3
votes
0 answers

ci_connect(): OCIEnvNlsCreate() failed

I am using Laravel 5 with yajra/laravel-oci8 . Problem is that I am getting this error: ErrorException in Oci8.php line 81: oci_connect(): OCIEnvNlsCreate() failed. There is something wrong with your system - please check that PATH includes the…
user2496520
  • 881
  • 4
  • 13
  • 36
3
votes
4 answers

Can PHP and Oracle pass complex types to each other?

I want to pass/bind an array of (key1, key2) to an Oracle PL/SQL stored procedure using PHP. I'm able to bind primitive types and arrays of primitive types, but haven't found a way to pass complex datatypes back and forth. Is this unsupported? So…
aw crud
  • 8,791
  • 19
  • 71
  • 115
3
votes
2 answers

Can I return values to PHP from an anonymous PL/SQL block?

I'm using PHP and OCI8 to execute anonymous Oracle PL/SQL blocks of code. Is there any way for me to bind a variable and get its output upon completion of the block, just as I can when I call stored procedures in a similar way? $SQL =…
aw crud
  • 8,791
  • 19
  • 71
  • 115
3
votes
0 answers

PHP 5.4 + Oracle 11.2g : return collection in a cursor

Assume, in Oracle 11.2g the following type: create type a_type is table of varchar2(30); the following record type: type a_record is record(id number(18) ,a_collection a_type ); the…
Pancho
  • 2,043
  • 24
  • 39
3
votes
2 answers

Link to specific Oracle instant client dynamic library on OS X

There's a widely-used Ruby gem (ruby-oci8) which uses a C-extension to call an Oracle C library (Oracle Instant Client). It creates a bundle (oci8lib_191.bundle) which calls routines in the the Oracle library (libclntsh.dylib.11.1). However, if one…
wadesworld
  • 13,535
  • 14
  • 60
  • 93
3
votes
1 answer

Rails 3.0 - can't load ruby-oci8 with Bundler

Rails n00b here - need some assistance. I am trying to port a Rails3 app from Linux to Windows. My Gemfile looks as follows: source 'http://rubygems.org' gem 'rails', '3.0.0' gem 'sqlite3-ruby', '1.2.5', :require => 'sqlite3' gem 'ruby-oci8',…
Val Blant
  • 1,664
  • 2
  • 24
  • 34
3
votes
1 answer

Script fails when oci8 required

I am new to ruby and I have this weird problem. I have installed ruby 1.9.3p125, Oracle11gXE(ver 11.2.0.2.0) on 64-bit Win7. I am able to run without any problems this script: require 'watir-webdriver' browser = Watir::Browser.new browser.close and…
tom
  • 123
  • 1
  • 11
3
votes
1 answer

PHP Oracle 10g very slow fetch

I'm not used to use Oracle, so I may not ask my question really well. I execute very simple SELECT queries from an Linux Apache server with PHP 5.3 (PECL Oci8 1.4.6, client 11.2.0.3.0) to an Oracle server (10g Enterprise Edition Release 10.2.0.1.0),…
Fabien Ménager
  • 140,109
  • 3
  • 41
  • 60
2
votes
1 answer

Pass multidimensional array to Oracle stored procedure

I have SP with custom type: Create Or Replace Type tyTestArrayType As Object (siF1 SmallInt, siF2 SmallInt, siF3 SmallInt); Create Or Replace Type tyTestArray Is Table Of tyTestArrayType; Create Or Replace Procedure prTestArray(pArr…
S2201
  • 1,339
  • 3
  • 18
  • 35
1 2
3
…
24 25