Using oracle stored procedures for postgresql database

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 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.

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

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

Hi,

Have a look at orafce for the plugins. Try ora2pg for initial migration.
There are differences in how you execute procedures (syntax), packages are
missing in PostgreSQL and so on. Please have a look at
http://wiki.postgresql.org/wiki/Converting_from_other_Databases_to_PostgreSQL#Oracle

Regards,
Jayadevan

On Fri, Sep 20, 2013 at 3:19 PM, nikhilruikar <nikhilruikar@gmail.com>wrote:

Hello

2013/9/20 BOUVARD Aurélien <Aurelien.BOUVARD@supinfo.com>

Hi ,

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

orafce was moved to github https://github.com/orafce/orafce

Regards

Pavel

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.

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

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