Hello again I've got the problem solved, thanks to all that helped.
After all the other issues were solved, it was simply that the query returned no rows. D'oh.
Cheers Mike On Jan 29, 2008, at 1:33 AM, Hermann Schwaerzler wrote:
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 hello Michael Muratet wrote: [...]I set the LANG='utf8' again and now I'm seeing: perl: warning: Setting locale failed. perl: warning: Please check that your locale settings: LANGUAGE = "utf8", LC_ALL = "utf8", LANG = "utf8" are supported and installed on your system. perl: warning: Falling back to the standard locale ("C").check if "locale -a" really outputs a locale named "utf8" as being installed on your system. more likely it is "es_US.utf8" or something similar. you have to use this when you set LANG! you probably know that in order to set the character-set for the communication with the oracle database-server you have to set NLS_LANG accordingly before starting the perl-program that does the connection? e.g. NLS_LANG=american_america.AL32UTF8 for utf8! regards hermann schwärzler -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQFHntbZpZ4QdpzGMxwRAriLAKDR7D66aUYtBIJ7DVynhdQ1UJZu3gCg45LH jxKMEUQ+3fAdZbws6TaAsz0= =xzbW -----END PGP SIGNATURE-----
