Re: ORA-24345: A Truncation or null fetch error occurred -ora2pg

Luca Ferrari <[email protected]>
Newsgroups gmane.comp.db.postgresql.performance,gmane.comp.db.postgresql.general
Message-ID <CAKoxK+417CrR9MeVkbXw2huKWZn2=2CU5fHrmDoQtX6eUbNWJw@mail.gmail.com> 
On Tue, Aug 13, 2019 at 10:23 AM Daulat Ram <[email protected]> wrote:
> Initially did not have LongReadLen set, so I thought this was the cause. But, I have set LongReadLen, on the db handle, equal to 90000000.

Apparently this is an oracle problem because it acceppted data longer
than its type, so my guess would be that in your table you have a
char(n) column that could be enlarged before the migration.
<https://support.oracle.com/knowledge/Siebel/476591_1.html>
Hope this helps.
And please report the version of ora2pg when asking for help.

Luca
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.