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.
>
>
