Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <gxallen@gmail.com>) id 1TP439-0003wc-8d
	for pgsql-admin@postgresql.org; Fri, 19 Oct 2012 04:19:07 +0000
Received: from mail-vc0-f174.google.com ([209.85.220.174])
	by magus.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <gxallen@gmail.com>) id 1TP431-00062p-H0
	for pgsql-admin@postgresql.org; Fri, 19 Oct 2012 04:19:06 +0000
Received: by mail-vc0-f174.google.com with SMTP id fk26so47742vcb.19
	for <pgsql-admin@postgresql.org>; Thu, 18 Oct 2012 21:18:58 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113;
	h=message-id:date:from:user-agent:mime-version:to:subject:references
	:in-reply-to:x-enigmail-version:content-type
	:content-transfer-encoding;
	bh=gx/h/HQlaOI2xNBZuTgEydcH5/DQpvwTvLHOxcfXyo4=;
	b=S4Xe4w4ZpJgsOVohj4xD/ptnq8OXJ4ueSAFa5QPasX5JTcX7G8F1U8ETdCHxrgLNtA
	ctoEh7Wjq+5U1Vd8EdWTwVkhsmOTy8Qt7QoKckqLuLkwg5iHMZGtimqfGHUJ9/YVMjrV
	xUbIZ3dbzIY6umHfEPJBebQ7okBStOLoBCOVYUBvoIy1gC7mGg85e6BfuCjXJPmnmHS+
	SiJ+WiucNp0GLasd+WbqiJpmLHlVoKy+nXsB3leJ5BlvgFWTgrUq3/gFdJXVXnO6a5LM
	tYAA83I0Bxz7RJ1wITsy6GAmd1ZLPeBQ8/3qN++joVgfKTTZ9j8tjD691t8KdETiWbOg
	Nabw==
Received: by 10.220.119.196 with SMTP id a4mr73090vcr.19.1350620338011;
	Thu, 18 Oct 2012 21:18:58 -0700 (PDT)
Received: from [192.168.1.5] (pool-71-190-193-233.nycmny.fios.verizon.net.
	[71.190.193.233])
	by mx.google.com with ESMTPS id k14sm670584vdh.19.2012.10.18.21.18.56
	(version=SSLv3 cipher=OTHER); Thu, 18 Oct 2012 21:18:57 -0700 (PDT)
Message-ID: <5080D4F0.5040504@gmail.com>
Date: Fri, 19 Oct 2012 00:20:00 -0400
From: Grant Allen <gxallen@gmail.com>
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64;
	rv:15.0) Gecko/20120907 Thunderbird/15.0.1
MIME-Version: 1.0
To: pgsql-admin@postgresql.org
Subject: Re: Migration from Postgresql 9 to Oracle 10g
References: 
 <CAM42borseyMiA0o4APWuo+08oWmOUpT1vNq8XzB0RFc_TAGpPQ@mail.gmail.com>
	<50804092.9060801@gmail.com> <5080C99B.7080408@ringerc.id.au>
In-Reply-To: <5080C99B.7080408@ringerc.id.au>
X-Enigmail-Version: 1.4.4
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
X-Pg-Spam-Score: -2.7 (--)
X-Archive-Number: 201210/86
X-Sequence-Number: 40202

On 18/10/2012 23:31, Craig Ringer wrote:
> On 10/19/2012 01:46 AM, Grant Allen wrote:
>> On 18/10/2012 02:13, Shams Khan wrote:
>>> Hi Experts,
>>>
>>> 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.
>>
>> Er, what?  What exactly do you mean "Oracle doesn't support DML's in ... procedures"?
> 
> I'm assuming the intention was to write "DDL".

Ah.  Well, not as plain statements - very true.  But wrap them in "execute immediate" and one is good to go :)

But we digress ... I'm still fascinated to find out what's driving the move away from Postgres.

Ciao
Fuzzy
:-)