[Dbix-class] Error when reading a CLOB field in an Oracle 10g database

[Rob Kinyon]

On Wed, Mar 9, 2011 at 12:16, Ivan Wills <ivan.wills at gmail.com> wrote:
>
>
> On 9 March 2011 22:04, Peter Edwards <peter at dragonstaff.co.uk> wrote:
>>
>> On 9 March 2011 00:11, Ivan Wills <ivan.wills at gmail.com> wrote:
>>>
>>> I have a Catalyst project using a DBIC model that when I try to search a
>>> table with a CLOB record the DBI throws an error ORA-24812 which is a USC2
>>> character code conversion error. I can run the same code out side of
>>> catalyst (by instantiating the model directly) and I don't get the error.
>>> The error looks like it should be Oracle's fault (which is basically what
>>> the Oracle documentation says) but some interaction with catalyst and dbix
>>> class probably sets some sort of configuration value that Oracle can't cope
>>> with. Does any one know what setting might be causing this?\
>>>
>>
>> Have you got this in your environment in both cases?
>>    NLS_LANG='AMERICAN_AMERICA.AL32UTF8'
>> Regards, Peter
>> http://perl.dragonstaff.co.uk
>
> I have tried setting NLS_LANG and NLS_CHARACTERSET neither seemed to have
> any effect.

How are you verifying that the environment setting has actually been
set? It may not be enough to just set the environment variable and
hope that it gets propagated.

Rob