Subject: Re: Oracle Package equivalent in Postgres
To: Firthouse banu <penguinsfairy@gmail.com>
Cc: "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
References: 
 <CAK_Ha4wFrkYcwGV=t3axcUXFmOOCOC1K2bUvcKRZXFCxtR136A@mail.gmail.com>
From: MichaelDBA <MichaelDBA@sqlexec.com>
Message-ID: <f459859b-4087-4b76-8bcb-3a70d732dfab@sqlexec.com>
Date: Thu, 6 Aug 2020 09:34:05 -0400
User-Agent: Mozilla/5.0 (Windows NT 10.0; WOW64; rv:52.0) Gecko/20100101
 PostboxApp/7.0.25
MIME-Version: 1.0
In-Reply-To: 
 <CAK_Ha4wFrkYcwGV=t3axcUXFmOOCOC1K2bUvcKRZXFCxtR136A@mail.gmail.com>
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 8bit
Content-Language: en-US
Precedence: bulk

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
>