Request a Demo
Home   >   mailing lists

Re: Oracle PL/SQL to pg/PSQL conversion documentation. - Mailing list pgsql-sql

From Michael Moore
Subject Re: Oracle PL/SQL to pg/PSQL conversion documentation.
Date
Msg-id CACpWLjOd-cimUXzc2QW4H8fPausxrvoCm87cGbohYdT_ABatZA@mail.gmail.com
Whole thread Raw
In response to Re: Oracle PL/SQL to pg/PSQL conversion documentation.  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-sql
Tree view
Thanks Adrian. I've seen that one before, and it is indeed very useful. Unfortunately it does not address many of the features that need converting. For example, how to deal with a BULK COLLECT,  TABLE functions, context variables. Maybe I am hoping for too much. Again, thanks, Mike

On Wed, Dec 2, 2015 at 12:47 PM, Adrian Klaver <adrian.klaver@aklaver.com> wrote:
On 12/02/2015 12:44 PM, Michael Moore wrote:
Ideally I would like to see some template/example documentation of
common feature conversion solutions. For example, "If you have a pl/sql
TABLE function, you can do the same thing in postgres this way ..." I
can generally Google specific problems and after enough time weeding out
the garbage, I can usually find what I want, but maybe somebody has it
all in one nice neat document and I just don't know about it.
Any links to such a resource would be greatly appreciated as well as any
other links which you think I might find useful.

http://www.postgresql.org/docs/9.4/interactive/plpgsql-porting.html

Thanks,Mike



--
Adrian Klaver
adrian.klaver@aklaver.com

pgsql-sql by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Oracle PL/SQL to pg/PSQL conversion documentation.
Next
From: Sribeiro
Date:
Subject: Re: ERROR while creating new user - could not open relation mapping file global/pg_filenode.map