Thread: Compatibility module for Oracles dbms_sql
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?Thanks in advance!
--
Ing. Diego M. Miranda | Recursiva
Bouchard 644 8º
Buenos Aires - Argentina
(54) 15 3518 8087
Bouchard 644 8º
Buenos Aires - Argentina
(54) 15 3518 8087
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