t me going in the right direction. I have to re-build this app.
From: "Bobak, Mark"
To: John Scoles
Cc: "dbi-users@perl.org"
Sent: Fri, February 18, 2011 10:56:27 AM
Subject: RE: Problem with UTF8 and array binding
Tired the NVARCHAR2,
m#UTF-8_vs._utf8_vs._UT
F8
Thanks,
Carl Furst
o/~ What a difference a byte makes... o/~
-Original Message-
From: Bobak, Mark [mailto:mark.bo...@proquest.com]
Sent: Friday, February 18, 2011 11:56 AM
To: Nelson, Erick [HDS]; dbi-users@perl.org
Subject: RE: Problem with UTF8 and arr
Tired the NVARCHAR2, it had no effect.
-Original Message-
From: John Scoles [mailto:sco...@pythian.com]
Sent: Friday, February 18, 2011 7:03 AM
To: Bobak, Mark
Cc: dbi-users@perl.org
Subject: Re: Problem with UTF8 and array binding
On 17/02/2011 4:38 PM, Bobak, Mark wrote:
Sorry
bruary 17, 2011 5:19 PM
To: dbi-users@perl.org
Subject: RE: Problem with UTF8 and array binding
I had this problem quite awhile ago with an old Oracle 9.2 database.
I don't remember why but the solution involved setting a couple of environment
vars.
Looking back at those ancient, no lo
A_NLS} = "$ENV{ORACLE_HOME}/ocommon/nls/admin/data";
-Original Message-
From: John Scoles [mailto:sco...@pythian.com]
Sent: Thursday, February 17, 2011 1:10 PM
To: dbi-users@perl.org
Subject: Re: Problem with UTF8 and array binding
On 17/02/2011 3:05 PM, Bobak, Mark wr
s into the picture?
-Mark
-Original Message-
From: John Scoles [mailto:sco...@pythian.com]
Sent: Thursday, February 17, 2011 4:10 PM
To: dbi-users@perl.org
Subject: Re: Problem with UTF8 and array binding
On 17/02/2011 3:05 PM, Bobak, Mark wrote:
Perhaps you have to declare you in
type mentioned above...
I don't see how/where NCLOB fits into the picture?
-Mark
-Original Message-
From: John Scoles [mailto:sco...@pythian.com]
Sent: Thursday, February 17, 2011 4:10 PM
To: dbi-users@perl.org
Subject: Re: Problem with UTF8 and array binding
On 17/02/2011 3:05
On 17/02/2011 3:05 PM, Bobak, Mark wrote:
Perhaps you have to declare you in type as a NCLOB??
Cheers
John
Hi all,
I'm running into a 'PLS-00418: array bind type must match PL/SQL table row
type' error, but only when passing UTF8 data.
The details are as follows. I have a PL/SQL packaged f
Hi all,
I'm running into a 'PLS-00418: array bind type must match PL/SQL table row
type' error, but only when passing UTF8 data.
The details are as follows. I have a PL/SQL packaged function that looks like
this:
FUNCTION MSTInsUpdCIT(
PI_CGP_ID IN VARCHAR2
,PI_CBL_ID
