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

ruby throws error for nil

Given the following class: require 'rubygems' require 'oci8' class DB attr_reader :handle def initialize(username, password, db) @handle = OCI8.new(username,password,db) #We show an error if we don't have a handle after we try to…
Nicolas de Fontenay
  • 2,170
  • 5
  • 26
  • 51
0
votes
1 answer

How to resolve ORA-01036

I am creating a online system using PHP and Oracle OCI8. Anyone here have encountered the error: Warning: oci_bind_by_name() [function.oci-bind-by-name]: Error while trying to retrieve text for error ORA-01036 in dbcontrol.php on line 50 Success…
QKWS
  • 1,069
  • 9
  • 22
  • 41
0
votes
1 answer

OCI8 in ruby does not close connections on error and leaves the application paused (it hangs)

I have an application that essentially does this: queue = SizedQueue.new(2) Thread.new do conn = OCI8.new(DSN) cursor = conn.exec([a query]) cursor.fetch { |rec| queue << rec } queue << :queue_ended cursor.close conn.logoff end.tap { |t|…
damau
  • 334
  • 4
  • 9
0
votes
2 answers

oci8 extention not working in php-5.4.3

I'm using wampserver and i want to use the oci8 to connect to the oracle database i enabled the oci8 but when ever i see my phpinfo(); it's not there can any one tell me what's going on. i have been searching everywhere for hours but i couldn't…
Basil Basaif
  • 362
  • 8
  • 20
0
votes
2 answers

Connecting as SYS to an Oracle Database from PHP OCI8

I'm trying to access the ORACLE database from PHP, i'm using WampServer Version 2.2 Apache 2.4.2 – PHP 5.4.3 and oracle 11g. I tried many ways including :
Basil Basaif
  • 362
  • 8
  • 20
0
votes
1 answer

Connect to Oracle with PHP using oci8 module and a dynamic connection string

I would like to connect to an Oracle DB from PHP using the oci8 module (oci_connect). I know how to do this, but the problem is I would like to do it dynamically based on a connection string of type "oci8://user_name:password@tns_name" The…
Adrian
  • 23
  • 4
0
votes
3 answers

Return a 'DESC package' in PHP using OCI

Hi I am trying to get information on an Oracle package directly from PHP using OCI8: $sql = 'DESC my_package'; $stmt = oci_parse($conn, $sql); oci_execute($stmt); this returns: Warning: oci_execute() [function.oci-execute]: ORA-00900: invalid SQL…
drenocartero
  • 4,941
  • 7
  • 26
  • 26
0
votes
1 answer

install oci8_11g extension in opensuse

I am using Oracle-11g as database server and suse 11 64bits server as an application server. I want to enable oci8 and oci8_11g extension in PHP so can any one tell me the steps for this Thankyou
Nisarg
  • 3,024
  • 5
  • 32
  • 54
0
votes
1 answer

Oracle module for PHP in Linux

Is there any method for direct access to remotely hosted Oracle Database without installing oracle in my computer. I already had the host name, database name, username and password of the remotely hosted Oracle database. I am using Red Hat…
Rajan
  • 196
  • 1
  • 1
  • 9
0
votes
2 answers

Oracle Global Temporary Table / PHP interaction question

I've never used the Global Temporary Tables however I have some questions how they will work in a php environment. How is data shared: Assuming persistent connections to oracle through php using oci8. Is the data tied to a database id? is it done…
Erratic
  • 459
  • 1
  • 5
  • 12
0
votes
1 answer

How to execute a scalar query with oci8 and ruby

I'd like to select a next id from a sequence in oracle using oci8 and ruby. What's the easist way of doing so? Example wrong code: id = @conn.exec( 'Select NEXT_ID.NEXTVAL from dual' ) .exec returns a cursor. Is there an easy way of just getting…
Martlark
  • 14,208
  • 13
  • 83
  • 99
0
votes
1 answer

Why wouldn't a perfect SQL statement execute on oci_excute?

I've some PHP code writing to an Oracle database via OCI8 library. I have a insert statement which wouldn't execute programmatically- if I print out the statement and run it via SquirrelSQL it would insert the data successfully. I have delete and…
NJD
  • 1
  • 3
-1
votes
1 answer

I Want to install PHP 7.4 on Oracle Linux 8 with the PHP OCI8 extension

I tried a lot of thing on internet but didn't worked, and i follow this steps on oracle linux documentation: client documentation php oci documentation commands with the follow erro: sudo dnf install oracle-instantclient-release-el8 sudo dnf install…
Guilherme Queiroz Ribeiro
  • 1
  • 1
-1
votes
2 answers

PHP Warning: PHP Startup: Unable to load dynamic library 'oci8_19' windows 11 (php8.1.20) tried most of the available solutions but nothing is working

tried most of the available solutions but nothing is working !!!! I have downloaded a fresh php from here which is php-8.1.20-nts-Win32-vs16-x64.zip in Windows 11 64-bit PC. This is working properly for all default libraries whenever I update the…
ANIK ISLAM SHOJIB
  • 3,002
  • 1
  • 27
  • 36
-1
votes
1 answer

I am trying to return an array of User objects but my variable $database->FetchArray() return false

My program does not execute the foreach because $database->FetchArray() is false. However my request is correct and executed ($success is equal to true). public static function FindBasicRecipients(): array|bool { $database = new…
vh-dev-web
  • 25
  • 6
1 2 3
…
24
25