Re: package conversion error from oracle to postgresql database !!!!!!!!!

[Sandeep Saxena <sandeep.lko@xxxxxxxxx>]

You can use orafce extension to get utl_file feature in postgres.

https://github.com/orafce/orafce

On Sun, Dec 12, 2021 at 12:47 AM dbatoCloud Solution <dbatocloud17@xxxxxxxxx> wrote:

Hi All,

While migrating oracle to PostgreSQL database using ora2pg tool. I have got this below error for the package. Could someone please help with this? 

psql:./schema/packages/package.sql:??: ERROR:  schema "utl_file" does not exist
LINE 75:    file_type utl_file.file_type := utl_file.fopen(file_dir, ...
                      ^
ERROR: an error occurs when importing file ./schema/packages/package.sql.
[ybos@doliordv265 comsod_code]$

Thanks

Ashok

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Ashokkumar Mani

 +91 81975 99922 

W: https://dbatocloudsolution.blogspot.in/ | E: dbatocloud17@xxxxxxxxx