select open change scope Open full search

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

Extensions / Compatibility

oraplsql

Oracle-compatible procedural SQL language for OpenTenBase.

pgext.cloud · Source code · Control file

Overview

Packageoraplsql
Version1.0
RepositoryUnspecified
Extension typeStandard
Project statusActive
Requires CREATE EXTENSIONYes
Requires preloadNo
TrustedNo
RelocatableNo
Schemapg_catalog
Stars520
Latest commit2025-11-06
Latest release2025-10-22
Catalogue updated2026-08-30

Related extensions

See also

orafceFunctions and operators that emulate a subset of functions and packages from the Oracle RDBMS
pg_dbms_jobExtension to add Oracle DBMS_JOB full compatibility to PostgreSQL
plpgsql_wrapOracle WRAP-equivalent PL/pgSQL language handler storing AES-256-GCM encrypted procedure source.
pg_dbms_metadataExtension to add Oracle DBMS_METADATA compatibility to PostgreSQL
pg_utl_smtpOracle UTL_SMTP compatibility extension for PostgreSQL
pg_statement_rollbackServer side rollback at statement level for PostgreSQL like Oracle or DB2
ivorysql_oraOracle Compatible extension on Postgres Database
pg_dbms_errlogEmulate DBMS_ERRLOG Oracle module to log DML errors in a dedicated table.
pg_dbms_lockExtension to add Oracle DBMS_LOCK full compatibility to PostgreSQL
oracle_fdwforeign data wrapper for Oracle access