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