On Sun, Jan 09, 2005 at 10:02:20AM -0700, Reidy, Ron wrote: > This is not a DBI issue ...
It's a DBD::Oracle one. Try explicitly setting $dbh->{ora_ph_csform} (see the docs). If all else fails then you could just hack the source to remove the code that checks for errors after OCIAttrSet(OCI_ATTR_CHARSET_FORM) calls. Tim. > >From the oerr utility: > > $ oerr ora 24328 > 24328, 00000, "illegal attribute value" > // *Cause: The attribute value passed in is illegal. > // *Action: Consult the users manual and specify a legal attribute value > // for the handle. > > ----------------- > Ron Reidy > Lead DBA > Array BioPharma, Inc. > > > -----Original Message----- > From: Yahui Shang [mailto:[EMAIL PROTECTED] > Sent: Saturday, January 08, 2005 5:57 PM > To: dbi-users@perl.org > Subject: connection from Perl 5.8.5 to Oracle 7.3.4 database > > > Hello: > > I am using perl version 5.8.5 to connect to Oracle 7.3.4 database. I > can fetch Date, Number, Float type of data from that database, but not > VARCHAR2 type of data. The error message is: > > DBD::Oracle::db prepare failed: ORA-24328: illegal attribute value (DBD > ERROR: OCIAttrSet OCI_ATTR_CHARSET_FORM) [for Statement "SELECT > convert(CC_ACCOUNT_NUM, > 'WE8ISO8859P1', 'WE8DEC') > FROM TEMP_PCC_BATCH_PAYMENT"] at x line 23. > > I have tried various options to reset NLS_LANG (to UTF8), however, none > of them works. Could someone shed some lights on this issue? Really > appreciate any help. > > Yahui > > > This electronic message transmission is a PRIVATE communication which contains > information which may be confidential or privileged. The information is > intended > to be for the use of the individual or entity named above. If you are not the > intended recipient, please be aware that any disclosure, copying, > distribution > or use of the contents of this information is prohibited. Please notify the > sender of the delivery error by replying to this message, or notify us by > telephone (877-633-2436, ext. 0), and then delete it from your system. > >