Hello,
I receive this error sometimes when I execute a procedure in a Package in Oracle 10g, the data returned has a CLOB field and some numbers and nvarchar2, could this be the problem? If I remove a field called title of type NVARCHAR2(255) the error dissapears.
Thanks.
ORA-01406 - Fetched column value was truncated
-
- Posts: 36
- Joined: Tue 18 Jan 2005 20:52
- Location: SPAIN
CREATE OR REPLACE PACKAGE mc_pk_get_mp_adm3_data_sec
AS
TYPE rcmp IS REF CURSOR;
PROCEDURE getphotosforadm3 (p_adm3 IN NUMBER, ds OUT rcmp);
END mc_pk_get_mp_adm3_data_sec;
/
CREATE OR REPLACE PACKAGE BODY Mc_Pk_Get_Mp_Adm3_Data_Sec
AS
PROCEDURE getphotosforadm3 (p_adm3 IN NUMBER, ds OUT rcmp)
IS
BEGIN
OPEN ds FOR
SELECT MC_MP.c_id,
MC_MP.d_title AS d_title,
MC_MP.f_dateon, MC_USERS.d_firstname,
MC_USERS.d_lastname, MC_USERS.d_email, ROWNUM
FROM MC_MP, MC_USERS
WHERE ( (MC_USERS.c_id(+) = MC_MP.c_usr_id)
AND (MC_MP.b_validated = 1)
AND (MC_MP.c_mic_id = 3)
AND (MC_MP.c_geo_id = p_adm3)
)
ORDER BY MC_MP.f_dateon DESC;
END;
END Mc_Pk_Get_Mp_Adm3_Data_Sec;
/
AS
TYPE rcmp IS REF CURSOR;
PROCEDURE getphotosforadm3 (p_adm3 IN NUMBER, ds OUT rcmp);
END mc_pk_get_mp_adm3_data_sec;
/
CREATE OR REPLACE PACKAGE BODY Mc_Pk_Get_Mp_Adm3_Data_Sec
AS
PROCEDURE getphotosforadm3 (p_adm3 IN NUMBER, ds OUT rcmp)
IS
BEGIN
OPEN ds FOR
SELECT MC_MP.c_id,
MC_MP.d_title AS d_title,
MC_MP.f_dateon, MC_USERS.d_firstname,
MC_USERS.d_lastname, MC_USERS.d_email, ROWNUM
FROM MC_MP, MC_USERS
WHERE ( (MC_USERS.c_id(+) = MC_MP.c_usr_id)
AND (MC_MP.b_validated = 1)
AND (MC_MP.c_mic_id = 3)
AND (MC_MP.c_geo_id = p_adm3)
)
ORDER BY MC_MP.f_dateon DESC;
END;
END Mc_Pk_Get_Mp_Adm3_Data_Sec;
/
We cannot reproduce your problem using the following code. Send us please
small working demo project to demonstrate the problem
and include script to create server objects to OraDirect.Net support address.
small working demo project to demonstrate the problem
and include script to create server objects to OraDirect.Net support address.
Code: Select all
oracleConnection1.Open();
oracleCommand1.CommandText = "mc_pk_get_mp_adm3_data_sec.getphotosforadm3";
oracleCommand1.CommandType = CommandType.StoredProcedure;
oracleCommand1.CreateParameters();
oracleCommand1.ExecuteNonQuery();
-
- Posts: 36
- Joined: Tue 18 Jan 2005 20:52
- Location: SPAIN
I've been looking for help about this error, I only receive it when I'm using your component, if I execute the same query with any other component, or using ODBC for example it works perfectly.
I've seen that in your component the "Fetch Buffer Size" is gone, where is this property in your component?
Has your component any type of limit in the size of the rows retrieved from a query?
Regards.
I've seen that in your component the "Fetch Buffer Size" is gone, where is this property in your component?
Has your component any type of limit in the size of the rows retrieved from a query?
Regards.