Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <ringerc@ringerc.id.au>) id 1TP3JT-0006k2-V1
	for pgsql-admin@postgresql.org; Fri, 19 Oct 2012 03:31:56 +0000
Received: from mail-pa0-f46.google.com ([209.85.220.46])
	by magus.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <ringerc@ringerc.id.au>) id 1TP3JM-0005P6-Nx
	for pgsql-admin@postgresql.org; Fri, 19 Oct 2012 03:31:54 +0000
Received: by mail-pa0-f46.google.com with SMTP id hz1so28869pad.19
	for <pgsql-admin@postgresql.org>; Thu, 18 Oct 2012 20:31:45 -0700 (PDT)
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
	d=google.com; s=20120113;
	h=message-id:date:from:user-agent:mime-version:to:cc:subject
	:references:in-reply-to:content-type:content-transfer-encoding
	:x-gm-message-state;
	bh=mDlm6Fu2wgJvNQwK5lhjNx2no8j7G5R+7dEr3yqeUg8=;
	b=Hj8MTg8B5AJrW4tY8dcmG/KctDe/NEIYao/VsEw/H63x2c5c28GjCu+GNqVJHfTF27
	+h8EtxFlJfStsvFW4PrBgFPLsVXtk/5LrGvunCuwVsHpLpJRlrlIJF1SJEbbK9YK33+M
	e/S0MQeN5CcJPac1lgmOfa0umANu+9NhHfpIFKZh2SB6nCYYi2XamCafKyqe2kdotK/l
	9sFacmips9zhPJchN6rjU28hNhafn6etdS1bnKPiWquqPBoB9OLtSdta8brAdSklrshG
	FIkVPe+S7FHTE+JGYoJAWvzSdNUshrUF3y56u7qkmz2P6Pb5lcbA0I5ywFw1ngtNIupX
	MlTg==
Received: by 10.68.213.33 with SMTP id np1mr1269802pbc.64.1350617504938;
	Thu, 18 Oct 2012 20:31:44 -0700 (PDT)
Received: from ayaki.localdomain (124-148-78-49.dyn.iinet.net.au.
	[124.148.78.49])
	by mx.google.com with ESMTPS id ho7sm510689pbc.3.2012.10.18.20.31.42
	(version=SSLv3 cipher=OTHER); Thu, 18 Oct 2012 20:31:44 -0700 (PDT)
Message-ID: <5080C99B.7080408@ringerc.id.au>
Date: Fri, 19 Oct 2012 11:31:39 +0800
From: Craig Ringer <ringerc@ringerc.id.au>
User-Agent: Mozilla/5.0 (X11; Linux x86_64;
	rv:16.0) Gecko/20121009 Thunderbird/16.0
MIME-Version: 1.0
To: Grant Allen <gxallen@gmail.com>
CC: pgsql-admin@postgresql.org
Subject: Re: Migration from Postgresql 9 to Oracle 10g
References: 
 <CAM42borseyMiA0o4APWuo+08oWmOUpT1vNq8XzB0RFc_TAGpPQ@mail.gmail.com>
	<50804092.9060801@gmail.com>
In-Reply-To: <50804092.9060801@gmail.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Gm-Message-State: 
 ALoCoQlPaWlGMCo3pqOdIbAxp1RZkRH3p23UWGn+SLcBqsY3n9eqDMvf0ewo4Wvl/al6jlEG4+i/
X-Pg-Spam-Score: -1.9 (-)
X-Archive-Number: 201210/85
X-Sequence-Number: 40201

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".

--
Craig Ringer