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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
