Thank you.
I have tried the option of explicitly setting $dbh->{ora_ph_csform}, however, it still does not work. My questions is: does DBD support character set WE8DEC? Or is DBD even compatible with Oracle 7.3.4? Thanks,
Yahui
Tim Bunce wrote:
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: [email protected] 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.
