MIME-Version: 1.0
Content-Type: text/plain;
 charset=UTF-8;
 format=flowed
Content-Transfer-Encoding: 7bit
Date: Thu, 18 Oct 2012 10:31:04 +0200
From: Gabriele Bartolini <Gabriele.Bartolini@2ndQuadrant.it>
To: Shams Khan <shams.khan22@gmail.com>
Cc: <pgsql-admin@postgresql.org>
Subject: Re: Migration from Postgresql 9 to Oracle 10g
In-Reply-To: 
 <CAM42borseyMiA0o4APWuo+08oWmOUpT1vNq8XzB0RFc_TAGpPQ@mail.gmail.com>
References: 
 <CAM42borseyMiA0o4APWuo+08oWmOUpT1vNq8XzB0RFc_TAGpPQ@mail.gmail.com>
Message-ID: <28e7bf5060708a323543621f1fe1d80b@2ndquadrant.it>
User-Agent: [X]con Webmail/0.4.2

 Hi Shams,

 On Thu, 18 Oct 2012 11:43:52 +0530, Shams Khan <shams.khan22@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.Bartolini@2ndQuadrant.it - www.2ndQuadrant.it