Hi Shams,
On Thu, 18 Oct 2012 11:43:52 +0530, Shams Khan <shams.kha...@gmail.com>
wrote:
I am in the process of migration from PG 9 to oracle. All of the
database objects has been migrated apart from functions. The main
issue I am facing with function code where DML statements are used in
the code. On the other side, Oracle doesn't support DML's in
functions
or procedures. I used ESF Database Migration tool in order to convert
and does some remaing task manually. Is there any tool by which can
convert functions as well?
I guess you are better off asking this to an Oracle forum or to Oracle
itself (or consultants).
Here I am sure you can find a lot of people (including myself) who are
really eager to talk about the inverse process and who are specialised
with that. We - for instance - manage Oracle to vanilla PostgreSQL
migrations with semi-automated tools able to convert PLSQL functions,
but not the other way around. Sorry. :(
Just for the record and to understand if this is due to PostgreSQL
limitations, are you in a position to give us technical/product reasons
for this decision?
Cheers,
Gabriele
--
Gabriele Bartolini - 2ndQuadrant Italia
PostgreSQL Training, Services and Support
gabriele.bartol...@2ndquadrant.it - www.2ndQuadrant.it
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
