Postgres Pro
Downloads
Home   >   mailing lists

Re: package conversion error from oracle to postgresql database !!!!!!!!! - Mailing list pgsql-admin

From Sandeep Saxena
Subject Re: package conversion error from oracle to postgresql database !!!!!!!!!
Date
Msg-id CAA3fAREmnY0vu97ivz5LUjXBvBwkL1kmKv8HTM8KY8oT0nw=YA@mail.gmail.com
Whole thread Raw
In response to package conversion error from oracle to postgresql database !!!!!!!!!  (dbatoCloud Solution <dbatocloud17@gmail.com>)
List pgsql-admin
Tree view
You can use orafce extension to get utl_file feature in postgres.




On Sun, Dec 12, 2021 at 12:47 AM dbatoCloud Solution <dbatocloud17@gmail.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@doliordv265 comsod_code]$


Thanks

Ashok

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

Ashokkumar Mani

 +91 81975 99922 

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



pgsql-admin by date:

Previous
From: dbatoCloud Solution
Date:
Subject: package conversion error from oracle to postgresql database !!!!!!!!!
Next
From: Mladen Gogala
Date:
Subject: Re: package conversion error from oracle to postgresql database !!!!!!!!!