ORA-12704: character set mismatch problem with DBD::Oracle
From: Jim Lynch (jwl_at_sgi.com)
Date: 01/25/05
- Previous message: Lincoln A Baxter: "RE: DBD::Oracle and CHLD Signal Handler"
- Next in thread: Lincoln A Baxter: "RE: ORA-12704: character set mismatch problem with DBD::Oracle"
- Maybe reply: Lincoln A Baxter: "RE: ORA-12704: character set mismatch problem with DBD::Oracle"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: Tue, 25 Jan 2005 14:27:25 -0500 To: dbi-users@perl.org
I'm trying to select from a table where the serial number apparently
looks like an octal number to Oracle and I haven't been able to figure
out how to convince it otherwise.
My last attempt looks like:
my $rc = $sth->bind_param(1,$serial,{ora_type=>ORA_STRING,
ora_csform=>SQLCS_NCHAR});
I get the error when I do the execute. $serial = 0800690C0A
If serial = abc or 123 it works fine. If I remove the leading zero it
works fine, which leads me to believe that something is converting that
into something else, like an octal number which obviously will fail.
I've tried ORA_CHAR andORA_VARCHAR.
This is and 8.1.7 Oracle installation on Linux.
Any suggestions?
Thanks,
Jim.
- Previous message: Lincoln A Baxter: "RE: DBD::Oracle and CHLD Signal Handler"
- Next in thread: Lincoln A Baxter: "RE: ORA-12704: character set mismatch problem with DBD::Oracle"
- Maybe reply: Lincoln A Baxter: "RE: ORA-12704: character set mismatch problem with DBD::Oracle"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
