Subject: Re: ORA-24345: A Truncation or null fetch error occurred -ora2pg
To: Daulat Ram <Daulat.Ram@exponential.com>,
 Luca Ferrari <fluca1978@gmail.com>
Cc: "pgsql-general@lists.postgresql.org" <pgsql-general@lists.postgresql.org>
References: 
 <BL0PR01MB5187E1C75192031D3ADA3CE49BD20@BL0PR01MB5187.prod.exchangelabs.com>
 <CAKoxK+417CrR9MeVkbXw2huKWZn2=2CU5fHrmDoQtX6eUbNWJw@mail.gmail.com>
 <BL0PR01MB518759BB39C66DE2A3B89E469BD20@BL0PR01MB5187.prod.exchangelabs.com>
 <17a34583-7035-056f-2cea-6d4d6e105593@aklaver.com>
 <BL0PR01MB518744C8DCB92DCA0F1328639BAD0@BL0PR01MB5187.prod.exchangelabs.com>
From: Adrian Klaver <adrian.klaver@aklaver.com>
Message-ID: <8ab0597a-d464-ade7-857b-727135ee874a@aklaver.com>
Date: Wed, 14 Aug 2019 07:13:43 -0700
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:60.0) Gecko/20100101
 Thunderbird/60.7.2
MIME-Version: 1.0
In-Reply-To: 
 <BL0PR01MB518744C8DCB92DCA0F1328639BAD0@BL0PR01MB5187.prod.exchangelabs.com>
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Language: en-US
Content-Transfer-Encoding: 7bit
Precedence: bulk

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