Re: Migration from Postgresql 9 to Oracle 10g

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
:-)