Hi,
Pharo Oracle Call Interface (https://github.com/Ironirc/Pharo-Oracle-Call-Interface) is a new project that is currently under development. It was started and implemented by Ivo Roefs.
This library allows you to connect to an Oracle SQL RDBMS from Pharo (versions 8 and up). It provides a binding with Oracle’s OCI (also known as the Oracle Call Interface) using FFI.
Usage
Once correctly installed on your local computer, you use OciClient to interact with the Oracle database:
| client rows |
client := OciClient new
environmentString: ‘pharotst202112_medium’;
username: ‘SCOTT’;
password: ‘TIGER’;
yourself.
rows := client query: ‘SELECT * FROM emp’.
client close.
rows.
Installation
To install this library you clone the repository and load BaselineOfPharoOracleCallInterface. This can be done using the Iceberg UI tools or with the following script:
Metacello new
baseline: ‘PharoOracleCallInterface’;
repository: ‘github://Ironirc/Pharo-Oracle-Call-Interface:main/‘;
load.
You have to make sure that the Pharo VM can access/load the necessary native library for your client side OS platform. The easiest way to get started is using Oracle Instant Client and an Oracle Cloud account. You also have to set up and configure access, contact your DBA for help.
Status
This project is new and currently under development. It should not be used for production applications. Basic queries are working on 32 and 64 bit Windows and 64 bit macOS.
We are looking for collaborators, fellow developers who can help.
Ivo & Sven