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

[Peter Edwards]

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 co=
pe
> with. Does any one know what setting might be causing this?\
>
>
Have you got this in your environment in both cases?
   NLS_LANG=3D'AMERICAN_AMERICA.AL32UTF8'

Regards, Peter
http://perl.dragonstaff.co.uk
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.scsys.co.uk/pipermail/dbix-class/attachments/20110309/8b7=
201a0/attachment.htm