Re: ORA-24345: A Truncation or null fetch error occurred -ora2pg - Mailing list pgsql-performance

From Luca Ferrari
Subject Re: ORA-24345: A Truncation or null fetch error occurred -ora2pg
Date
Msg-id CAKoxK+417CrR9MeVkbXw2huKWZn2=2CU5fHrmDoQtX6eUbNWJw@mail.gmail.com
Whole thread Raw
In response to ORA-24345: A Truncation or null fetch error occurred -ora2pg  (Daulat Ram <Daulat.Ram@exponential.com>)
Responses RE: ORA-24345: A Truncation or null fetch error occurred -ora2pg  (Daulat Ram <Daulat.Ram@exponential.com>)
RE: ORA-24345: A Truncation or null fetch error occurred -ora2pg  (Daulat Ram <Daulat.Ram@exponential.com>)
List pgsql-performance
On Tue, Aug 13, 2019 at 10:23 AM Daulat Ram <Daulat.Ram@exponential.com> 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



pgsql-performance by date:

Previous
From: "王若楠"
Date:
Subject: performance bottlenecks on lock transactionid
Next
From: Daulat Ram
Date:
Subject: RE: ORA-24345: A Truncation or null fetch error occurred -ora2pg