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

2019-08-14 Thread Adrian Klaver
On 8/14/19 2:39 AM, Daulat Ram wrote: Hi Adrian , We have the below output. What we need to change. I am not an ora2pg user so I don't know what to suggest for below. I would say the best thing to do would be to file an issue here: https://github.com/darold/ora2pg/issues Along with the ori

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

2019-08-14 Thread Daulat Ram
Daulat Ram ; Luca Ferrari Cc: pgsql-performa...@lists.postgresql.org; pgsql-general@lists.postgresql.org Subject: Re: ORA-24345: A Truncation or null fetch error occurred -ora2pg On 8/13/19 10:34 AM, Daulat Ram wrote: > H, > > We are using below the ora2pg version and the data types for ta

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

2019-08-13 Thread Adrian Klaver
2 Thanks, Daulat -Original Message- From: Luca Ferrari Sent: Tuesday, August 13, 2019 8:32 PM To: Daulat Ram Cc: pgsql-performa...@lists.postgresql.org; pgsql-general@lists.postgresql.org Subject: Re: ORA-24345: A Truncation or null fetch error occurred -ora2pg On Tue, Aug 13, 2019

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

2019-08-13 Thread Daulat Ram
tgresql.org; pgsql-general@lists.postgresql.org Subject: Re: ORA-24345: A Truncation or null fetch error occurred -ora2pg On Tue, Aug 13, 2019 at 10:23 AM Daulat Ram wrote: > Initially did not have LongReadLen set, so I thought this was the cause. But, > I have set LongReadLen, on the db

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

2019-08-13 Thread Luca Ferrari
On Tue, Aug 13, 2019 at 10:23 AM Daulat Ram 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 9000. Apparently this is an oracle problem because it acceppted data longer than its type, so my guess would

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

2019-08-13 Thread Daulat Ram
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 e