Re: Oracle Package equivalent in Postgres

From: MichaelDBA <MichaelDBA(at)sqlexec(dot)com>
To: Firthouse banu <penguinsfairy(at)gmail(dot)com>
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Oracle Package equivalent in Postgres
Date: 2020-08-06 13:34:05
Message-ID: f459859b-4087-4b76-8bcb-3a70d732dfab@sqlexec.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

ora2pg is a standard way to migrate stuff from ORA to PG.  It also will
attempt to translate packages/procs/funcs from PL/SQL to PL/pgSQL.  For
packages, the output can be separate files with
package_name_func/proc_name, or you can group packages into separate
output directories where you can subsequently load them into separate PG
schemas to distinguish one ORA package from another.

Regards,
Michael Vitale

Firthouse banu wrote on 8/6/2020 8:22 AM:
> Hi Postgres master minds,
>
> Am currently working on migrating databases from  oracle to Postgres.
> Am going to work on crons and packages in oracle which needs to be
> converted in Postgres. How to convert package in oracle to Postgres.
> Is there any equivalent in Postgres if not how it works in Postgres.
>
> Eagerly  waiting for replies.
>
> Thanks
>

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message JC JC 2020-08-06 14:03:24 Re: Oracle Package equivalent in Postgres
Previous Message Holger Jakobs 2020-08-06 12:41:27 Re: Oracle Package equivalent in Postgres