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(dot)klaver(at)aklaver(dot)com