We have tried it already.Actually there are a quite a lot of syntax changes
required .Which is making task time consuming.
You can find below statement in ora2pg website.
Ora2Pg do its best to automatically convert your Oracle database to
PostgreSQL but there's still manual works to do. The Oracle specific PL/SQL
code generated for functions, procedures, packages and triggers has to be
reviewed to match the PostgreSQL syntax.
Thanks
Suhas
--
View this message in context: http://postgresql.1045698.n5.nabble.com/Tool-for-translation-of-Oracle-PL-SQL-into-Postgresql-PL-pgSQL-tp5790797p5790845.html
Sent from the PostgreSQL - pgadmin support mailing list archive at Nabble.com.