HI , 
still I am getting the error..

Oracle Insatlled in Japanses.
NLS_LANG = JAPANESE
NLS_CHARACTERSET = ja16EUC

1. I saved my perl file and converted my file to euc-JP using iconv.
2.set OS Language is EUC

got the same error , here what I notice that the error messgae showing
+ the exact query. (I think it means its trying to pass the correct qu
+ery to Oracle)

But showing invalid character after SELECT .

But the same query what ever perl is trying to pass to oracle , execut
+ing pefectly in SQLPLUS.

Where is the problem here?

Also tried with charset SJIS and UTF-8..
getting the same error..

Thanks
Sri
[download]