Tmax OpenSQL Orafce

Introduction

This is the new orafce extension for PostgreSQL. We are diverging from orafce v4.13.5 and will implement new features in this repository from now. The new changes will be recorded in CHANGELOG.

The documentation on the original orafce features up to version 4.13.5 can be found in the following list:

Orafce Documentation

• Chapter 1. Overview
• Chapter 2. Notes on Using orafce
• Chapter 3. Data Types
• Chapter 4. Queries
• Chapter 5. SQL Function Reference
• Chapter 6. Package Reference
• Chapter 7. Transaction Behavior

Oracle to PostgreSQL Migration Guide

• Chapter 0. Preface
• Chapter 1. Pre-migration Configuration
• Chapter 2. Migrating Syntax Elements
• Chapter 3. Migrating Functions
• Chapter 4. Migrating SQL Statements
• Chapter 5. Migrating PL/SQL
• Chapter 6. Notes on Using orafce
• Appendix A. Correnspondence with Oracle Databases

Dependencies

• CMake version 3.10 or later
• PostgreSQL server version 10 or later
• PostgreSQL server development files version 10 or later

Building

cmake -S . -B build
cmake --build build

Testing

The new orafce uses pgTAP for tests. Follow the instructions below to test the extension.

Install pgTAP and its dependencies

# Clone source repository
$ git clone https://github.com/theory/pgtap.git

# Build pgTAP
$ cd pgtap
$ make
$ make install
$ make installcheck

# Install Perl parser library for pgTAP
$ cpan TAP::Parser::SourceHandler::pgTAP

Run Tests

$ cd orafce
$ pg_prove -U ${username} tests/${feature_set_to_test}/${feature_to_test}.sql