RE: connection from Perl 5.8.5 to Oracle 7.3.4 database
From: Ron Reidy (Ron.Reidy_at_arraybiopharma.com)
Date: 01/09/05
- Next message: Michael Ragsdale: "RE: Perl 5.6 to 5.8 caveats for DBI"
- Previous message: Ron Reidy: "RE: Question on DBI connection to Oracle"
- Maybe in reply to: Yahui Shang: "connection from Perl 5.8.5 to Oracle 7.3.4 database"
- Next in thread: Tim Bunce: "Re: connection from Perl 5.8.5 to Oracle 7.3.4 database"
- Reply: Tim Bunce: "Re: connection from Perl 5.8.5 to Oracle 7.3.4 database"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: Sun, 9 Jan 2005 10:02:20 -0700 To: "Yahui Shang" <yahui.shang@globalstar.com>, <dbi-users@perl.org>
This is not a DBI issue ...
>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:yahui.shang@globalstar.com]
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.
- Next message: Michael Ragsdale: "RE: Perl 5.6 to 5.8 caveats for DBI"
- Previous message: Ron Reidy: "RE: Question on DBI connection to Oracle"
- Maybe in reply to: Yahui Shang: "connection from Perl 5.8.5 to Oracle 7.3.4 database"
- Next in thread: Tim Bunce: "Re: connection from Perl 5.8.5 to Oracle 7.3.4 database"
- Reply: Tim Bunce: "Re: connection from Perl 5.8.5 to Oracle 7.3.4 database"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
