Skip to content

Latest commit

 

History

History
57 lines (39 loc) · 1.75 KB

README.md

File metadata and controls

57 lines (39 loc) · 1.75 KB

Pharo-Oracle-Call-Interface

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.

There is also support for prepared statements with binding, check the unit tests for examples.

Installation

To install this library you clone this repository and load BaselineOfPharoOracleCallInterface. This can be done using the Iceberg UI tools and 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. If you are interested please help out. Basic queries are working on 32 and 64 bit Windows and 64 bit macOS.