Maybe you will get more enthusiastic support in an Oracle forum... It is curious that you want to migrate form a fairly current PostgreSQL version (you didn't say which one) to an Oracle version that is already out of (Premier) support and will be terminally abandoned next year. Shams Khan wrote: > On the other side, Oracle doesn't support DML's in functions > or procedures. That's not true. You can use INSERT, UPDATE and DELETE in PL/SQL. You can do about anything in PL/SQL. Yours, Laurenz Albe -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin