Table of Contents Previous Next


1 Introduction

Database Compatibility for Oracle means that an application runs in an Oracle environment as well as in the EDB Postgres Advanced Server (Advanced Server) environment with minimal or no changes to the application code. Developing an application that is compatible with Oracle databases in the Advanced Server requires special attention to which features are used in the construction of the application. For example, developing a compatible application means choosing compatible:
System and built-in functions for use in SQL statements and procedural logic.
Stored Procedure Language (SPL) when creating database server-side application logic for stored procedures, functions, triggers, and packages.
For applications written using the Oracle Call Interface (OCI), EnterpriseDB’s Open Client Library (OCL) provides interoperability with these applications. For detailed information about using the Open Client Library, please see the EDB Postgres Advanced Server OCI Connector Guide.
Advanced Server contains a rich set of features that enables development of database applications for either PostgreSQL or Oracle. For more information about all of the features of Advanced Server, please consult the user documentation available at the EnterpriseDB website.

1 Introduction

Table of Contents Previous Next