in reply to DBD::Oracle::st fetchrow_hashref failed: ORA-24345

  1. Please update your post to include an open <code>, as you've gotten mangled.
  2. Are you certain the field is VARCHAR2(80)? Not to second guess you, but every time I've seen that error, it was associated with a LOB.
  3. What do you mean by 'special characters'? Non-alphanumerics? Non-ASCII? If you are dealing with high-bit characters, can you show us your connector? Have you modified $ENV{NLS_LANG}?

It looks like there's a message on the perl.dbi.users mailing list that might be relevant. It suggests the problem is UTF related, and we need to debug your connector.

#11929 First ask yourself `How would I do this without a computer?' Then have the computer do it the same way.

Replies are listed 'Best First'.
Re^2: DBD::Oracle::st fetchrow_hashref failed: ORA-24345
by gopalr (Priest) on Sep 11, 2013 at 13:00 UTC

    Hi

    These are the special characters:

    ^$!@&*_+-={}|\;:''>,./?~`+    °~_+{}|¿>?~_+|¿>?`-=\¿,.---¿,03¶,83¤¼,,-,¼°°~_°

    I have resolved this issue by setting up the environment variable to '.WE8ISO8859P1' from .AL32UTF8

    $ENV{'NLS_LANG'} = '.WE8ISO8859P1'

    Now it works fine.. Thanks for your guidance

[reply]
[d/l]
[select]

      Glad to have provided guidance, and thank you for posting your solution in case another knowledge seeker runs into a similar problem.

      #11929 First ask yourself `How would I do this without a computer?' Then have the computer do it the same way.

[reply]

In Section Seekers of Perl Wisdom