Re: Compatibility module for Oracles dbms_sql - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Compatibility module for Oracles dbms_sql
Date
Msg-id 54778A4E.7010502@aklaver.com
Whole thread Raw
In response to Compatibility module for Oracles dbms_sql  (Diego Miranda <diego.miranda@recursiva.com.ar>)
List pgsql-general
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


pgsql-general by date:

Previous
From: Diego Miranda
Date:
Subject: Compatibility module for Oracles dbms_sql
Next
From: "Andrus"
Date:
Subject: Re: Converting xml to table with optional elements