odpi | ODPI-C : Oracle Database Programming Interface for Drivers | Database library

by oracle C Version: v4.6.1 License: Non-SPDX

X-Ray Key Features Code Snippets Community Discussions(10)Vulnerabilities Install Support

kandi X-RAY | odpi Summary

odpi is a C library typically used in Database, Oracle applications. odpi has no bugs, it has no vulnerabilities and it has low support. However odpi has a Non-SPDX License. You can download it from GitHub.

Oracle Database Programming Interface for C (ODPI-C) is an open source library of C code that simplifies access to Oracle Database for applications written in C or C++. It is a wrapper over Oracle Call Interface (OCI) that makes applications and language interfaces easier to develop. ODPI-C supports basic and advanced features of Oracle Database and Oracle Client. See the homepage for a list.

Support

Quality

Security

License

Reuse

Support

odpi has a low active ecosystem.

It has 239 star(s) with 80 fork(s). There are 30 watchers for this library.

It had no major release in the last 12 months.

There are 16 open issues and 162 have been closed. On average issues are closed in 90 days. There are no pull requests.

It has a neutral sentiment in the developer community.

The latest version of odpi is v4.6.1

Quality

odpi has no bugs reported.

Security

odpi has no vulnerabilities reported, and its dependent libraries have no vulnerabilities reported.

License

odpi has a Non-SPDX License.

Non-SPDX licenses can be open source with a non SPDX compliant license, or non open source licenses, and you need to review them closely before use.

Reuse

odpi releases are available to install and integrate.

Installation instructions are available. Examples and code snippets are not available.

Top functions reviewed by kandi - BETA

kandi's functional review helps you automatically verify the functionalities of the libraries and avoid rework.
Currently covering the most popular Java, JavaScript and Python libraries. See a Sample of odpi

Get all kandi verified functions for this library.

odpi Key Features

No Key Features are available at this moment for odpi.

odpi Examples and Code Snippets

No Code Snippets are available at this moment for odpi.

Community Discussions

Trending Discussions on odpi

Packaging Issues PyInstaller of Python application with Oracle Database Connection

Unable to use amancevice/superset docker image to use Oracle DB as datasource

How to fetch oracle type NUMBER as string or int/uint?

cx_Oracle on Docker : DPI-1047: 64-bit Oracle Client library cannot be loaded: "libclntsh.so

Node js connection to Oracle DB gives DPI-1047

DPI-1047: Cannot locate a 64-bit Oracle Client library from nodejs code

Linux. Connect ot Oracle. cx_Oracle.DatabaseError: DPI-1047 Cannot locate a 64-bit Oracle Client library: "libclntsh.so

How do I get count of rows from Oracle SELECT

Simple ODPI-C statement execution example gives ORA-00922

How to install Oracle Client Library from a Jupyter Notebook with Python?

QUESTION

Packaging Issues PyInstaller of Python application with Oracle Database Connection

Asked 2021-Feb-23 at 13:50

I am trying to package a python application using pyinstaller. I am using cx_oracle and the oracle instant client to connect to an oracle database. I am working on Windows 10. My application works fine before I package it. But after packaging, the following error occurs when I try to run the executable file:

cx_Oracle.DatabaseError: DPI-1072: the Oracle Client library version is unsupported

This error occurs in the line cx_Oracle.init_oracle_client(lib_dir=r"instantclient_19_9"). According to the ODPI log, the Oracle Instant Client is loaded successfully, but while validating, the error occurs. The problem is not due to a different Oracle Instant Client version on the system. I have checked for other versions on the systems, but there are none. Also, when I remove the Oracle Instant Client that I am trying to load, a different error occurrs, which says that not Oracle Instant client was found. When I package the application while mocking or omitting the database connection, the packaging works fine.

I have tried everything on two separate systems, on which I experience the same issues. Another person could reproduce my issues as well. Also, I can replicate this error with the following toy example:

There needs to be no Oracle database present. The Oracle Instant Client needs to be installed into the folder where the following file is located.

...

ANSWER

Answered 2021-Feb-22 at 02:32

Triple check the correct Oracle client is being loaded. Set the environment variable DPI_DEBUG_LEVEL to 64 before starting Python. (See the cx_Oracle Initialization documentation). This will show how cx_Oracle is looking for the Instant Client libraries, and will let you make sure there is no other (older) oci.dll somewhere on the computer that is being used.

Check you are on a supported OS version (i.e not Windows 7).

Check you have all the Instant Client libraries (obviously you don't need JDBC files): https://docs.oracle.com/en/database/oracle/oracle-database/19/lnoci/instant-client.html#GUID-6895DB45-97AA-4738-9959-BD677D610186

Make sure the computer has the correct VS Redistributable installed.

Source https://stackoverflow.com/questions/66280638

QUESTION

Unable to use amancevice/superset docker image to use Oracle DB as datasource

Asked 2020-Sep-25 at 02:48

I'm trying to test if superset would be adecuate for our data visualization needs. As I've no knowledge of python, I'm using a docker image of a superset installation (v0.37.1) published with all the libraries needed to connect to different databases (https://github.com/amancevice/docker-superset). When I try to set up a new database source to an Oracle database I get this error in the superset.log:

...

ANSWER

Answered 2020-Sep-25 at 02:48

When you download Oracle Instant Client Basic or Basic Light ZIP packages from here, then run something like this in your Dockerfile:

Source https://stackoverflow.com/questions/64046595

QUESTION

How to fetch oracle type NUMBER as string or int/uint?

Asked 2020-Jul-09 at 08:13

I'm fetching a row from oracle database using ODPI-C in C++ and NUMBER(19,0) type appears to be double, so in some cases the field value comes corrupted (e.g. in db viewer shows 5187413295700304461 but after fetch it's transformed into 5.1874132957002998e+18 which is not quite correct).

Reading the field value is done by

...

ANSWER

Answered 2020-Jul-09 at 08:13

Rows can be fetch using dpiVar*s. Simply before dpiStmt_fetch I defined dpi_Var* using this call

Source https://stackoverflow.com/questions/62808893

QUESTION

cx_Oracle on Docker : DPI-1047: 64-bit Oracle Client library cannot be loaded: "libclntsh.so

Asked 2020-Jun-28 at 23:33

I'm trying to build a Docker image with cx_Oracle.

Here is the Dockerfile I'm using :

...

ANSWER

Answered 2020-Jun-28 at 23:33

With RPMs prior to 19c, you need to update the system library search path when you install Instant Client RPMs. The recommended way is to use ldconfig as shown in Oracle's sample 18c Dockerfile:

Source https://stackoverflow.com/questions/62479000

QUESTION

Node js connection to Oracle DB gives DPI-1047

Asked 2020-May-03 at 22:51

I am trying to connect to Oracle DB to node JS. SQL developer is already installed and working successfully, SQL developer is connected to server database using tnsnames.ora file. But when i try to run below code

...

ANSWER

Answered 2020-May-02 at 22:17

The reason SQL Developer does not complain about the same problem as your node.js app is SQL Developer is using a pure Java JDBC driver to connect to the database. The JDBC thin driver is entirely written in Java and is included in the installation of the product "SQL Developer".

You should get a similar error message if you ask SQL Developer to connect to the database using a thick driver (OCI library)

There are situations where you will need the thick driver to connect in SQL Developer. This link will explain when: https://www.thatjeffsmith.com/archive/2019/04/sql-developer-19-1-connections-thick-or-thin/

Your node.js oracledb module requires a client side library (OCI) in order to connect to the database so please download and install an oracle instant client before any connections are tried.

Best of luck

Source https://stackoverflow.com/questions/61566087

QUESTION

DPI-1047: Cannot locate a 64-bit Oracle Client library from nodejs code

Asked 2020-Apr-23 at 13:37

I'm trying to establish a simple database connection to run a sql query from an express/node app and when I hit my endpoint, I see the following error:

...

ANSWER

Answered 2020-Apr-23 at 13:37

The oracle 'oracledb' driver (node-oracledb) requires the Oracle client to connect to the database.

You can find the Oracle client at https://www.oracle.com/database/technologies/instant-client.html

Source https://stackoverflow.com/questions/61376928

QUESTION

Linux. Connect ot Oracle. cx_Oracle.DatabaseError: DPI-1047 Cannot locate a 64-bit Oracle Client library: "libclntsh.so

Asked 2020-Apr-22 at 09:41

I have error "cx_Oracle.DatabaseError: DPI-1047: Cannot locate a 64-bit Oracle Client library: "libclntsh.so: cannot open shared object file: No such file or directory". See https://oracle.github.io/odpi/doc/installation.html#linux for help"

I saw https://oracle.github.io/odpi/doc/installation.html#oracle-instant-client-zip and How to fix: cx_Oracle.DatabaseError: DPI-1047: Cannot locate a 64-bit Oracle Client library - Python

I always work on Windows and only learing on Linux system. I need help for this issue. Connect to Oracle from python:

...

ANSWER

Answered 2020-Apr-22 at 09:41

Problem solved. Maybe It will be hlepfully: download rpm(oracle-instantclient12.2-basic, oracle-instantclient12.2-devel, oracle-instantclient12.2-devel).

of course, needs only oracle-instantclient12.2

Source https://stackoverflow.com/questions/61158053

QUESTION

How do I get count of rows from Oracle SELECT

Asked 2020-Apr-06 at 23:08

I can't find proper way to get count of rows returned after successful execution of SELECT statement via ODPI-C.

Hope you can help me.

EDITED: There is a function

...

ANSWER

Answered 2020-Apr-06 at 23:07

This is not ODPI-C specific. Oracle Database doesn't provide this automatically on SELECT statements. You have to fetch the rows and then count them. Or run 'SELECT COUNT'.

Source https://stackoverflow.com/questions/61060353

QUESTION

Simple ODPI-C statement execution example gives ORA-00922

Asked 2020-Mar-29 at 00:46

I'm trying to execute simple sql query using ODPI-C

...

ANSWER

Answered 2020-Mar-27 at 21:36

The DDL statement should not have a semicolon at the end. That is a client statement separator, not part of the statement. Change it to:

Source https://stackoverflow.com/questions/60889510

QUESTION

How to install Oracle Client Library from a Jupyter Notebook with Python?

Asked 2020-Feb-17 at 22:45

I am trying to establish a connection from a Jupyter Notebook using the following Python code:

...

ANSWER

Answered 2020-Feb-17 at 21:51

I strongly expect you'll need to install the Oracle client libraries before starting Jupyter, because the OS library search path needs to contain the client library directory, and you can't set this inside a running process. The ODPI-C link does contain the steps you need to follow. You can install the latest Instant Client ZIP or RPM "Basic" package.

The cx_Oracle installation manual is here: https://cx-oracle.readthedocs.io/en/latest/user_guide/installation.html#installing-cx-oracle-on-linux

Source https://stackoverflow.com/questions/60270787

Community Discussions, Code Snippets contain sources that include Stack Exchange Network