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
On Fri, Sep 20, 2013 at 3:19 PM, nikhilruikar <nikhilruikar@xxxxxxxxx> wrote:
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@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general