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

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(at)gmail(dot)com>
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(at)doliordv265 comsod_code]$
>
>
> Thanks
>
> Ashok
>
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>
> Ashokkumar Mani
>
> +91 81975 99922
>
> W: https://dbatocloudsolution.blogspot.in/
> <http://dbatocloudsolution.blogspot.in/> | E: dbatocloud17(at)gmail(dot)com
>
>
>
>