| From: | Daulat Ram <Daulat(dot)Ram(at)exponential(dot)com> |
|---|---|
| To: | "pgsql-performance(at)lists(dot)postgresql(dot)org" <pgsql-performance(at)lists(dot)postgresql(dot)org>, "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | ORA-24345: A Truncation or null fetch error occurred -ora2pg |
| Date: | 2019-08-13 08:23:11 |
| Message-ID: | BL0PR01MB5187E1C75192031D3ADA3CE49BD20@BL0PR01MB5187.prod.exchangelabs.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-performance |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | stan | 2019-08-13 09:54:03 | A GROUP BY question |
| Previous Message | Shital A | 2019-08-13 06:20:21 | Re: Fwd: Postgres HA - pacemaker RA do not support auto failback |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kristian Ejvind | 2019-08-13 11:08:21 | Re: zabbix on postgresql - very slow delete of events |
| Previous Message | Sverre Boschman | 2019-08-13 07:02:32 | Re: Strange runtime partition pruning behaviour with 11.4 |