Re: Using oracle stored procedures for postgresql database

On 9/22/2013 9:01 PM, nikhilruikar wrote:
>         Thanks for response, but what I am exactly looking at is using stored
> procedures written for oracle as it is for postgres database.
>
>           Is it possible?
>           If not is there any referance document available for converting
> oracle stored procedures to postgresql

EnterpriseDB has a commercial version of Postgres to which has been
added extensive Oracle compatibility.  Its supposed to be able to run
most Oracle pl/sql code with little or no change.

The community open source version of Postgres has a pl/pgsql language,
which is superficially similar to pl/sql, but there are significant
differences, not the least of which it only supports 'functions' and not
'procedures'.


--
john r pierce                                      37N 122W
somewhere on the middle of the left coast