Thread: Using oracle stored procedures for postgresql database

Hi
      I am planning to migrate oracle database to postgres. I need to know
if there are any plugins or tool with which I can use stored procedures
written in oracle schema for postgres with out changing them.

Thanks in advance



--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Using-oracle-stored-procedures-for-postgresql-database-tp5771714.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

Hi ,

Maybe it will help you : http://orafce.projects.pgfoundry.org/ 

Regards,


Aurélien 


 Afin de contribuer au respect de l'environnement, merci de n'imprimer ce mail qu'en cas de nécessité.


-----Message d'origine-----
De : pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.org] De la part de nikhilruikar
Envoyé : vendredi 20 septembre 2013 11:50
À : pgsql-general@postgresql.org
Objet : [GENERAL] Using oracle stored procedures for postgresql database

Hi 
      I am planning to migrate oracle database to postgres. I need to know if there are any plugins or tool with which
Ican use stored procedures written in oracle schema for postgres with out changing them.
 

Thanks in advance



--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Using-oracle-stored-procedures-for-postgresql-database-tp5771714.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

hi all

       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

Thanks in advance




-----
Nikhil Ruikar
contact me at :- nikhilruikar@gmail.com
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Using-oracle-stored-procedures-for-postgresql-database-tp5771714p5771941.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

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