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

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 original error message include the below and the 
settings, if any, for NLS_*, CLIENT_ENCODING from your ora2pg.conf file.

> 
> bash-4.2$ ora2pg -c ora2pg.bidder.conf -t SHOW_ENCODING
> 
> Current encoding settings that will be used by Ora2Pg:
>          Oracle NLS_LANG AMERICAN_AMERICA.AL32UTF8
>          Oracle NLS_NCHAR AL32UTF8
>          Oracle NLS_TIMESTAMP_FORMAT YYYY-MM-DD HH24:MI:SS.FF6
>          Oracle NLS_DATE_FORMAT YYYY-MM-DD HH24:MI:SS
>          PostgreSQL CLIENT_ENCODING UTF8
>          Perl output encoding ''
> Showing current Oracle encoding and possible PostgreSQL client encoding:
>          Oracle NLS_LANG AMERICAN_AMERICA.WE8MSWIN1252
>          Oracle NLS_NCHAR WE8MSWIN1252
>          Oracle NLS_TIMESTAMP_FORMAT YYYY-MM-DD HH24:MI:SS.FF6
>          Oracle NLS_DATE_FORMAT YYYY-MM-DD HH24:MI:SS
>          PostgreSQL CLIENT_ENCODING WIN1252
> bash-4.2$
> 
> thanks


-- 
Adrian Klaver
adrian.klaver@aklaver.com