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