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
-1
votes
1 answer

SQLPLUS / OCI8 => ORA-12154: TNS:could not resolve the connect identifier specified (OCIError)

I am in WINDOWS 10Pro x64. I installed gem for my RUBY environment: ruby_oci8 I installed ORACLE C:\instantclient_12_2 and added to PATH, I also installed SQLPLUS utils and added to PATH I need to connect to REMOTE ORACLE DB my tnsnames.ora, pointed…
Davide Tessarollo
  • 67
  • 8
-1
votes
1 answer

CentOS 7 - PHP Command line - Unable to load dynamic library 'oci8'

Has anyone ever come across this error when upgrading to php 7.2.34 ? It seems to be an error while running a php script under a user directory but for the life of me i can't find a solution yet. I'm assuming (not super great with linux) that it's…
Rob
  • 153
  • 1
  • 3
  • 14
-1
votes
2 answers

composer require yajra/laravel-oci8:^8 in laravel 8

PHP version 7.3.22 Running on Laravel Framework version 8 root@df77c47e6f1e:/var/www/oracle-laravel-v8# composer require yajra/laravel-oci8:^8 PHP Warning: PHP Startup: Unable to load dynamic library 'oci8_12c' (tried:…
devit chea
  • 53
  • 1
  • 6
-1
votes
3 answers

calling the column_name in the table while connecting via Oracle DB

I am trying to get the value from the table(employee)connecting through the oracle database. Since there are 100s of values in one column, I would need to iterate the table and get the exact value. I have the code that works if I use the index no.…
seleniumlover
  • 159
  • 2
  • 3
  • 14
-1
votes
2 answers

Unable to load dynamic library php_oci8_12c.dll

Ok, so i have the same problem. To fix it i had to install oracle instant client and an NTS dll of oci8_12c when i start my WAMP i get this error: [20-Feb-2018 13:40:38 UTC] PHP Warning: PHP Startup: Unable to load dynamic library…
MrZzippo p
  • 24
  • 1
  • 1
  • 7
-1
votes
1 answer

Why does oci_connect() throw an "undefined function" exception even though function_exists('oci_connect') returns true?

I have been struggling for the last few days to get PHP to connect to an oracle DB. I have been doing this with a MAMP stack installed on a window machine (it is available for windows and ensures a uniform development stack for our team). After…
Geoff
  • 1
  • 1
-1
votes
1 answer

Ruby - OCI Library Initialization Error

Does anyone have any suggestions as to why I might be getting the error below? This is on a windows 10 machine with both 32 and 64 bit oracle 12c clients installed (not the instant client). I have looked at this post, but I am not sure if it is…
Garct
  • 31
  • 3
-1
votes
1 answer

Insert data in clob column and varchar column in a single insert statement using PHP Oci8

I want to insert the data in clob and varchar2 column in a single insert statement in oracle. $conn=oci_connect(); if (!$conn) { $e = oci_error(); // For oci_connect errors pass no handle echo "if not…
Faisal
  • 85
  • 2
  • 9
-1
votes
1 answer

ruby:using regex i want to split sql statements

i'm using ruby and sinatra and oci8 and i want to run an sql file which contain multiple sql statements but oci8 just can let me execute one statement str="INSERT INTO AA(NAME) VALUES ('asasa')" @conn1 = OCI8.new(DB_USER, DB_PASSWORD,…
sakhri Mohamed Amine
  • 11
  • 3
-1
votes
3 answers

Centos 6 PHP OCI8 extention is not working (Undefined function oci_connect())

I am using Centos 6 64 bit OS. Recently i have installed OCI8 extension with php. After making all configuration i tried to execute the function oci_connect to connect with a Oracle Database remotely. Unfortunately i got this error: Fatal error:…
iamlancer
  • 117
  • 2
  • 4
  • 15
-1
votes
1 answer

Error when changing MySQL syntax to Oracle syntax in SQL code in PHP

So I got this project to take a page that was previously using MySQL and now using Oracle. So I installed the oci8 PHP module and created a test page to make my changes on. This is a page I am updating and I am not an Oracle guy. I am a…
NerdyBird
  • 109
  • 1
  • 5
  • 11
-1
votes
1 answer

Install oracle and php oracle extension(OCI8) in Opensuse environment

I am using oracle database server Now I want to install oracle in Opensuse environment.It completelty work in ubuntu and Windows.So please tell me steps to install php,oci8 extension and oracle in Opensuse. This is urgent. Thank you.
Hardik Patel
  • 706
  • 5
  • 14
-2
votes
2 answers

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

I just installed xampp v3.2.2 on my pc. I want to create connection string to oracle using php. when i start Apache on xampp, always show popup window "the procedure entry point OCIstmtGetNextResult could not be located in the dynamic link library…
MF. Hujaeri
  • 33
  • 1
  • 7
-3
votes
1 answer

Connect PHP (GoDaddy) to local Oracle Database

I've been trying to find a way for a while but I had no success! (OCI, PDO..) I need Oracle (Express) or something in my php installation. Could anyone help me? GoDaddy PHP to Oracle DB. Thanks!
Traian Tatic
  • 681
  • 5
  • 18
1 2 3
…
24
25