Re: Compatibility module for Oracles dbms_sql

On 11/27/2014 12:21 PM, Diego Miranda wrote:
> Hi everyone!
> I'm in need of assistance. Currently I'm working in a project that was
> started with an Oracle database, but later migrated to Postgres. It has
> various procedures that make use of the dbms_sql package. Is there any
> compatibiliity module in Postgres for this Oracle package?

Not in the community version, though a quick look seems to some of this
is covered by EXECUTE:

http://www.postgresql.org/docs/9.3/interactive/plpgsql-statements.html#PLPGSQL-STATEMENTS-EXECUTING-DYN

Enterprise DB does offer it in their paid version:

http://www.enterprisedb.com/docs/en/8.4/oracompat/Postgres_Plus_Advanced_Server_Oracle_Compatibility_Guide-122.htm


>
> Thanks in advance!
> --
> *Ing. Diego M. Miranda | Recursiva**
> **Bouchard 644 8º
> Buenos Aires - Argentina
> (54) 15 3518 8087 *


--
Adrian Klaver
adrian.klaver@aklaver.com