RE: Problem with UTF8 and array binding....

Sorry, but I'm not sure I understand the suggestion. NCLOB is (as far as I can see), not in the picture... Datatype of table is VARCHAR2(255 CHAR) The PL/SQL table type is table of table_name.column_name%type indexed by binary_integer IN TYPE is named type defined as the table type mentio

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

Problem with UTF8 and array binding....

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