From: Adrian Klaver <adrian.klaver@aklaver.com>
To: Daulat Ram <Daulat.Ram@exponential.com>
To: Luca Ferrari <fluca1978@gmail.com>
Cc: pgsql-general@lists.postgresql.org <pgsql-general@lists.postgresql.org>
Subject: Re: ORA-24345: A Truncation or null fetch error occurred -ora2pg
Date: Wed, 14 Aug 2019 07:13:43 -0700
Message-ID: <8ab0597a-d464-ade7-857b-727135ee874a@aklaver.com> (raw)
In-Reply-To: <BL0PR01MB518744C8DCB92DCA0F1328639BAD0@BL0PR01MB5187.prod.exchangelabs.com>
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>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: adrian.klaver@aklaver.com, Daulat.Ram@exponential.com, fluca1978@gmail.com, pgsql-general@lists.postgresql.org
Subject: Re: ORA-24345: A Truncation or null fetch error occurred -ora2pg
In-Reply-To: <8ab0597a-d464-ade7-857b-727135ee874a@aklaver.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox