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

How do I require a specific version of a ruby gem?

Specifically, the ruby-oci8 gem. I have both 1.0.7 and 2.0.4 installed. I want 1.0.7. I can just require oci8, but I don't get the version I want. irb(main):001:0> require 'oci8' => true irb(main):002:0> OCI8::VERSION => "2.0.4" I can require…
KenB
  • 6,587
  • 2
  • 35
  • 31
12
votes
2 answers

How to sort by numbers first with Oracle SQL query?

I have this table with a 'title' field which is varchar2 and I want to select all rows and sort them first by number and then by the alphabet as it normally happens. For instance, I currently get this using a simple ORDER BY title in the…
rfgamaral
  • 16,546
  • 57
  • 163
  • 275
12
votes
1 answer

How to connect to Oracle in go

I gather there are two ways to connect to Oracle DB in Go (on windows): github.com/tgulacsi/goracle github.com/mattn/go-oci8 But for someone of my level (beginner in open source+golang), those two methods/drivers are awfully tricky. It's also a…
himekami
  • 1,419
  • 3
  • 13
  • 21
9
votes
2 answers

PDO_OCI vs OCI8

I'm working on a new project and trying to determine if I should use PDO_OCI or oci8 for a database connection. Unfortunately I don't think anyone has really compared the two. The information I have is as follows so that you know why I'm concerned…
Christian South
  • 359
  • 2
  • 9
8
votes
6 answers

PHP oci8 won't install through pecl: "fatal error: oci8_dtrace_gen.h"

I am trying to connect my fedora 25 webserver - php to Oracle db. To do this I need to pecl install oci8. However I get this error: /bin/sh /var/tmp/pear-build-roottqYEC6/oci8-2.1.4/libtool --mode=compile cc -I. -I/var/tmp/oci8 -DPHP_ATOM_INC…
user4691770
7
votes
1 answer

CHAR semantics and ORA-01461

I maintain a PHP driven application with Oracle backend (OCI8 functions). The app is developed with Oracle 10g XE and deployed on whatever version the customer owns. The application handles single-byte text (ISO-8859-15) and I've never had any…
Álvaro González
  • 142,137
  • 41
  • 261
  • 360
7
votes
1 answer

How does one enable the OCI8 PHP extension, using the Oracle Instant Client, in Ubuntu 18.04 LTS with PHP-FPM and NGINX?

I'm using the latest PHP packages available from https://launchpad.net/~ondrej/+archive/ubuntu/php . When I build and install the OCI8 extension, everything appears to be in order, but despite enabling the extension in the PHP-FPM configuration, its…
Ben Johnson
  • 2,507
  • 3
  • 29
  • 29
7
votes
6 answers

Unable to load dynamic library 'oci8.so' (PHP 7.2)

Since the update of PHP 7.1 to PHP 7.2 I can't install oci8. I have this error: root@3ab6027c8d95:/var/www# php -v PHP Warning: PHP Startup: Unable to load dynamic library 'oci8.so' (tried:…
Shen
  • 131
  • 1
  • 2
  • 7
6
votes
1 answer

dyld: lazy symbol binding failed for php oic8 on Apple M1

On Intel based MacOS my installation process of php-oci8 was fine. After I moved to the new architecture Apple M1, I got strange exception. And can’t understand how to resolve it. Installation process: brew install php cd ~/Downloads curl -O…
denirun
  • 61
  • 3
6
votes
4 answers

How to enable oci in xampp 5.6.3?

I am facing some issue while starting Apache server via XAMPP. I have installed XAMPP Version 5.6.3. When I start the Apache server from xampp control panel, an error message is displayed as shown below: On clicking 'OK' button, another dialog box…
Harshrossi
  • 287
  • 1
  • 7
  • 19
6
votes
1 answer

How do I install OCI8 to an existing PHP?

According to this (Installing OCI8 from PECL, automated), all I have to do is type in pecl oci8 install. But that only gets me the following error, repeatedly. No releases available for package pecl.php.net/oci8. Another website suggested that I try…
zack_falcon
  • 4,186
  • 20
  • 62
  • 108
6
votes
4 answers

oci_connect() works only from command line

OK, so I have this terrible problem with oci, apache, php and suse. First off, versions: PHP 5.3.15 (cli) Apache/2.2.22 (Linux/SUSE) OCI8 1.4.9 SUSE 12.2 32 bit Oracle client 10.2.0.4 Problem I have really simple php file:
maialithar
  • 3,065
  • 5
  • 27
  • 44
6
votes
1 answer

Ruby cannot see NLS_LANG environmental variable

I'm running a ruby script on CentOS, and installed ruby via rvm (1.9.3). I've set the NLS_LANG variable in .bash_profile. [app@box stasis]$ echo $NLS_LANG en_US.UTF-8 [app@box stasis]$ which ruby ~/.rvm/rubies/ruby-1.9.3-p194/bin/ruby However when…
robertrv
  • 695
  • 2
  • 11
  • 16
5
votes
1 answer

OCI8 php extension installation on windows server

I have specific problem with making OCI8 work on my server installation. First setup: Win 2008 Server 32bit ZendServer for PHP with Apache2.2 PHP version 5.3.14 which was without php_oci8 files No oracle things installed I need to be able to…
Yoshi
  • 125
  • 1
  • 2
  • 9
5
votes
5 answers

oci_connect Blank Page in PHP

UPDATE (5/21/2010) SUCCESS! So after MUCH $head->desk()'ing, I've solved it. Remember kids, be wary of the instant client version you use, dependent on the virtualization settings! I had been installing the generic Instant Client (not aware our ESX…
Bryan
  • 51
  • 1
  • 6
1
2 3
…
24 25