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

Daulat Ram <[email protected]>
Newsgroups gmane.comp.db.postgresql.general,gmane.comp.db.postgresql.performance
Message-ID <BL0PR01MB5187E1C75192031D3ADA3CE49BD20@BL0PR01MB5187.prod.exchangelabs.com>
Hi team ,
I am getting the below error while fetching the data from Oracle 12c using ora2pg.

DBD::Oracle::st fetchall_arrayref failed: ORA-24345: A Truncation or null fetch error occurred (DBD SUCCESS_WITH_INFO: OCIStmtFetch, LongReadLen too small and/or LongTruncOk not set)ERROR no statement executing (perhaps you need to call execute first) [for Statement "SELECT "USERS_ID","NAME","USERS" FROM "GBOPSUI"."USER_GROUP_USERS_V5" a"] at /usr/local/share/perl5/Ora2Pg.pm line 14110.


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.

Thanks,
Daulat
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.