select open change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Extensions / Compatibility

orafce

Functions and operators that emulate a subset of functions and packages from the Oracle RDBMS

pgext.cloud · Source code · License text · Control file · PGXN

Overview

Packageorafce
Version4.16.10
PostgreSQL versions14 · 15 · 16 · 17 · 18
RepositoryPGDG
Extension typeStandard
Requires CREATE EXTENSIONYes
Requires preloadNo
TrustedNo
RelocatableNo
Stars541
Latest commit2026-08-30
Latest release2026-06-04
Catalogue updated2026-09-19

Related extensions

Required by

orafce_mailImplementation of utl mail and DBMS MAIL packages

See also

ivorysql_oraOracle Compatible extension on Postgres Database
db2fceDB2 compatibility functions, types, operators, and SYSIBM.SYSDUMMY1 for PostgreSQL.
babelfishpg_tsqlSQL Server Transact SQL compatibility
pg_dbms_metadataExtension to add Oracle DBMS_METADATA compatibility to PostgreSQL
pg_statement_rollbackServer side rollback at statement level for PostgreSQL like Oracle or DB2
pgttExtension to add Global Temporary Tables feature to PostgreSQL
session_variableRegistration and manipulation of session variables and constants
tds_fdwForeign data wrapper for querying a TDS database (Sybase or Microsoft SQL Server)
pg_dbms_lockExtension to add Oracle DBMS_LOCK full compatibility to PostgreSQL
pg_dbms_jobExtension to add Oracle DBMS_JOB full compatibility to PostgreSQL