From: Grant Allen <gxallen@gmail.com>
To: pgsql-admin@postgresql.org
Subject: Re: Migration from Postgresql 9 to Oracle 10g
Date: Thu, 18 Oct 2012 13:46:58 -0400
Message-ID: <50804092.9060801@gmail.com> (raw)
In-Reply-To: <CAM42borseyMiA0o4APWuo+08oWmOUpT1vNq8XzB0RFc_TAGpPQ@mail.gmail.com>
References: <CAM42borseyMiA0o4APWuo+08oWmOUpT1vNq8XzB0RFc_TAGpPQ@mail.gmail.com>
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
:-)
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: gxallen@gmail.com
Subject: Re: Migration from Postgresql 9 to Oracle 10g
In-Reply-To: <50804092.9060801@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox