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 :-) -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
