oracle-call-interface Questions
4
I need to connect to an ADW instance provisioned in my OCI space. The documentation to connect shows me how to connect using wallet credentials, but using sql developer. I am able to connect using ...
Ephesus asked 12/9, 2019 at 10:45
9
Solved
I have a simple test program that when I run I get:
./hello: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory
I link it like this:
$(...
Panpsychist asked 16/5, 2012 at 13:11
3
Solved
I have a simple php script:
<?php
$DB = '//10.11.201.170:1521/XE';
$DB_USER = 'BIOTPL';
$DB_PASS = 'biotpl';
$DB_CHAR = 'AL32UTF8';
$conn = oci_connect($DB_USER, $DB_PASS, $DB, $DB_CHAR...
Schist asked 28/11, 2016 at 11:33
4
my docker starts giving error after a recent update. Existing containers works but I can not build or run any image.
A simple
docker run hello-world
gives me an error:
docker: Error resp...
Geranial asked 31/12, 2019 at 12:22
1
I require help to get number of rows from select statement which contain where clause. I have tried various option. But it didn't work for me. I have shown my code snippet below.
I'm getting o/p "...
Soothsayer asked 2/9, 2019 at 11:12
1
Solved
I am attempting to do two things using the PHP OCI Oracle functions:
Run a package procedure within an Oracle database.
Once the package has ran, query a temporary table to get the results of the...
Fourpenny asked 12/4, 2020 at 0:55
1
My app is on:
ruby-2.6.4
Rails 4.2.8
activerecord-4.2.8
I'm upgrading a rails app to ruby-2.6.4 When running a rake task in development, for testing, I am getting errors for BigDecimal() and .../...
Mannino asked 14/2, 2020 at 13:3
4
I am currently inserting records one-by-one into a table from C++ code using OCI. The data is in a hashmap of structs, I iterate over the elements of the map, binding the attributes of the struct t...
Strafford asked 12/10, 2011 at 0:7
2
Solved
For OCIErrorGet() it is documented that it might return multiple errors, which I use to extract with the following method for OCI_SUCCESS_WITH_INFO, but currently not for OCI_ERROR:
void check_err...
Emperor asked 11/9, 2013 at 6:55
11
Solved
Can I find out when the last INSERT, UPDATE or DELETE statement was performed on a table in an Oracle database and if so, how?
A little background: The Oracle version is 10g. I have a batch applic...
Halfhearted asked 5/11, 2008 at 13:26
2
Solved
I downloaded SQuirreL SQL and I want to use it as an Oracle client, but when I go to Drivers tab, the following jars are missing:
Oracle OCI Driver
Oracle Thin Driver
How can I fix this probl...
Hint asked 1/8, 2016 at 7:58
2
Solved
I have created a Docker Image with PHP7.0-FPM and Apache 2.4. I have installed InstantClient 12.2 (basic + sdk) and I have installed oci8 like this :
RUN echo "instantclient,/usr/lib/oracle/12.2/i...
Demonstrate asked 12/12, 2017 at 11:7
1
In order to access an remote Oracle database from php, I had to activate the extension php_oci8_12c. But when I do, it does not appear in the phpinfo().
On the other hand, I get in the php logs the...
Xylography asked 13/1, 2017 at 10:36
4
Solved
I am working on a file loader program.
The purpose of this program is to take an input file, do some conversions on its data and then upload the data into the database of Oracle.
The problem that...
Wahlstrom asked 14/7, 2014 at 10:10
4
Solved
I'm using XAMPP and trying to configure Oracle connection for sql.
I uncommented the line extension=php_oci8.dll and at first it ended up with an error (that oci.dll is missing), but later I downl...
Allayne asked 29/12, 2013 at 13:1
3
Solved
I'm receiving the following error when trying to do a PDO OCI SQL query on one of my web servers:
SQLSTATE[HY000]: OCISessionBegin: ORA-21561: OID generation failed
I've confirmed that the Oracl...
Ramires asked 29/10, 2013 at 16:21
2
Solved
I have a simple php script:
<?php
$db_user = 'myusername';
$db_pass = 'mypassword';
$db_sid = 'mysid';
$conn = oci_connect( $db_user, $db_pass, $db_sid );
?>
When I run it (from a browser ...
Nightingale asked 25/3, 2015 at 14:2
1
I have a computer which acts as a server for Oracle database 11g Enterprise. I want to use another computer, a PC that is running Windows XP SP3, as a client of this server.
So I decided to insta...
Uremia asked 21/9, 2014 at 22:7
1
OCI Connect
Based upon the above, it states that one should avoid OCI connection on Windows. Have someone configured it on Windows? I have gone through all other threads, this and this, using Wind...
Headmost asked 24/11, 2015 at 12:10
2
I would need to connect to Oracle DB in my PHP codes.
I'm using Windows Server 2012, IIS 8 with PHP Manager, and PHP version 5.5.11.
I opened IIS PHP Manager, then go to PHP Extensions, then I en...
Semiskilled asked 22/8, 2014 at 10:17
3
Recently I updated my opensuse 12.3 to the newer 13.1
Unfortunately, I'm not able to compile the pdo_oci.so needed.
Using this guide, y could compile the extnention on 12.3:
http://forums.opensu...
Nitrification asked 1/1, 2014 at 23:54
2
Solved
When you develop a Java application that talks to oracle DBs, there are 2 options right? One is oracle thin driver, and the other is OCI driver that requires its own installation (please correct if...
Centralization asked 24/5, 2010 at 10:35
2
Solved
When I try to connect to my database, everything is ok, but when I try to use the query() command to execute a SQL statement I get this error:
The connection was reset
The connection to the s...
Amiens asked 20/4, 2015 at 17:50
0
I am working on an old PHP web app that uses Oracle as a backend. I don't have direct access to this database.
In the old app they are using str_replaces instead of oci_bind_by_name to replace var...
Charlottcharlotta asked 11/3, 2015 at 19:22
2
I'm trying to configure a simple connection between my local WAMP server and some Oracle 11.1.0.7 I have.
Apparently PHP has all sorts of solutions and magic situations where it fails to start.
I'...
Sholom asked 1/2, 2012 at 16:10
1 Next >
© 2022 - 2025 — McMap. All rights reserved.