From: | Grant Allen <gxallen(at)gmail(dot)com> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: Migration from Postgresql 9 to Oracle 10g |
Date: | 2012-10-19 04:20:00 |
Message-ID: | 5080D4F0.5040504@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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
:-)
From | Date | Subject | |
---|---|---|---|
Next Message | teyking2003 | 2012-10-19 05:55:26 | Re: Database in psql |
Previous Message | Craig Ringer | 2012-10-19 03:31:39 | Re: Migration from Postgresql 9 to Oracle 10g |