Received: from makus.postgresql.org ([98.129.198.125])
	by malur.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <gxallen@gmail.com>) id 1TOuAV-0007Tc-0O
	for pgsql-admin@postgresql.org; Thu, 18 Oct 2012 17:46:03 +0000
Received: from mail-gh0-f174.google.com ([209.85.160.174])
	by makus.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <gxallen@gmail.com>) id 1TOuAP-0006da-BK
	for pgsql-admin@postgresql.org; Thu, 18 Oct 2012 17:46:02 +0000
Received: by mail-gh0-f174.google.com with SMTP id g15so2473554ghb.19
	for <pgsql-admin@postgresql.org>; Thu, 18 Oct 2012 10:45:56 -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=r8oqDXbwDzitDQVi6LCpJ7h3rZaZOe0crgjrRCVLyyg=;
	b=lmTqZU3TZePKsyDo2V/LYOY+zbrcUTuOuEIE+41wlG8nmreM4WzEisK3o9B97MLMG2
	5Ha/00anz3kXUHZ9UcQe5W+42ow7PqAvGINNh6txAoomGIwYarT9L7qZu49AiZSN9VPQ
	auQsFADlNybKSFNsTA+TuNANwfXb50ZwPxCZ/xY9HfhqeWgSjWp+WJ8ZyswvZEpl7h+V
	/HRMqDeNCKpYfBm4s9WJ/f3nBRuW/f3No7+fjlQlZscdF/tVb/NkMA21aq0pR8HioQku
	6C943bQ5CCuecLIWsqwbvy0lJw5P9yHnLiuUkkntefBBk7oEj0wiJ97O1RvNBrPH5kdj
	HoJQ==
Received: by 10.100.213.15 with SMTP id l15mr6707927ang.45.1350582356334;
	Thu, 18 Oct 2012 10:45:56 -0700 (PDT)
Received: from ?IPv6:2620:0:1003:1000:a19a:6113:e994:8e9c?
	([2620:0:1003:1000:a19a:6113:e994:8e9c])
	by mx.google.com with ESMTPS id a7sm12197511yhe.14.2012.10.18.10.45.54
	(version=SSLv3 cipher=OTHER); Thu, 18 Oct 2012 10:45:54 -0700 (PDT)
Message-ID: <50804092.9060801@gmail.com>
Date: Thu, 18 Oct 2012 13:46:58 -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>
In-Reply-To: 
 <CAM42borseyMiA0o4APWuo+08oWmOUpT1vNq8XzB0RFc_TAGpPQ@mail.gmail.com>
X-Enigmail-Version: 1.4.4
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
X-Pg-Spam-Score: -2.6 (--)
X-Archive-Number: 201210/79
X-Sequence-Number: 40195

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"?  Several million Oracle developers will be shocked to hear they've been writing phantom code updating, inserting, deleting etc. in their PL/SQL.  Assuming that's what you mean by DML.  Can you provide an example?

And +1 to the other comments on being curious about the motivation for the migration in this direction.

Ciao
Fuzzy
:-)