Beefy Boxes and Bandwidth Generously Provided by pair Networks
"be consistent"
 
PerlMonks  

Re: DBD::Oracle::st fetchrow_hashref failed: ORA-24345

by kennethk (Abbot)
on Sep 06, 2013 at 16:48 UTC ( #1052736=note: print w/ replies, xml ) Need Help??


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.


Comment on Re: DBD::Oracle::st fetchrow_hashref failed: ORA-24345
Select or Download Code
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

      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.

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1052736]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others exploiting the Monastery: (5)
As of 2015-07-05 04:41 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (60 votes), past polls