Dear support,
I have a problem with the new version. I have functions like this one:
PROCEDURE GetStringResource( islocal IN VARCHAR2, classKeyOrVirtualPath IN VARCHAR2, resourceKey IN VARCHAR2, cLANGUAGE IN VARCHAR2, cVALUE OUT VARCHAR2 )
IS
cQuery VARCHAR2(4000);
BEGIN
IF( islocal = 'Y' ) THEN
cQuery := 'SELECT VALUE INTO :result FROM WEBSITE.RESOURCES_LOCAL WHERE VIRTUALPATH = :1 AND RESOURCEKEY = :2 AND LANGUAGE = :3';
ELSE
cQuery := 'SELECT VALUE INTO :result FROM WEBSITE.RESOURCES_GLOBAL WHERE CLASSKEY = :1 AND RESOURCEKEY = :2 AND LANGUAGE = :3';
END IF;
EXECUTE IMMEDIATE cQuery INTO cVALUE USING classKeyOrVirtualPath, resourceKey, cLANGUAGE;
EXCEPTION
WHEN NO_DATA_FOUND THEN
BEGIN
cVALUE := resourceKey;
cQuery := 'INSERT INTO WEBSITE.RESOURCES_MISSING( CK_OR_VP, RESOURCEKEY, LANGUAGE, ISLOCAL ) VALUES (:1, :2, :3, :4)';
EXECUTE IMMEDIATE cQuery USING classKeyOrVirtualPath, resourceKey, cLANGUAGE, islocal;
COMMIT;
EXCEPTION
WHEN OTHERS THEN
NULL;
END;
WHEN OTHERS THEN
NULL;
END GetResource;
where I extract the string resources from tables the last char is missing.
I call the function in this way:
OracleConnection ocn = new OracleConnection(ConfigurationManager.ConnectionStrings["WEBSITE"].ConnectionString);
ocn.Unicode = true;
OracleCommand ocmd = new OracleCommand("WEBSITE.PMNG_RESOURCES.GETSTRINGRESOURCE", ocn);
ocmd.CommandType = CommandType.StoredProcedure;
ocmd.Parameters.Add("ISLOCAL", (_isLocal ? "Y" : "N"));
ocmd.Parameters.Add("CLASSKEYORVIRTUALPATH", _classKeyOrVirtualPath);
ocmd.Parameters.Add("RESOURCEKEY", resourceKey);
ocmd.Parameters.Add("LANGUAGE", getCulture(culture));
// OracleParameter opRet = new OracleParameter("CVALUE", OracleDbType.VarChar, (int)Int16.MaxValue);
OracleParameter opRet = new OracleParameter("CVALUE", OracleDbType.VarChar, 4000);
opRet.Direction = ParameterDirection.Output;
ocmd.Parameters.Add(opRet);
ocn.Open();
try
{
ocmd.ExecuteNonQuery();
oRet = ocmd.Parameters["CVALUE"].Value;
if (oRet.ToString().Equals(String.Empty))
oRet = null;
}
catch{}
with previous versions 6.70.xxx everything was ok.
Could you help me?
Many thanks in advance
[6.80.xxx] OUT VARCHAR2 issue, last char missing?!?
-
- Devart Team
- Posts: 2420
- Joined: Wed 02 Nov 2011 09:44
-
- Devart Team
- Posts: 2420
- Joined: Wed 02 Nov 2011 09:44
-
- Devart Team
- Posts: 2420
- Joined: Wed 02 Nov 2011 09:44
The new build of dotConnect for Oracle 6.80.350 is available for download now!
It can be downloaded from http://www.devart.com/dotconnect/oracle/download.html (trial version) or from Registered Users' Area (for users with valid subscription only).
For more information, please refer to http://www.devart.com/forums/viewtopic.php?t=23996
It can be downloaded from http://www.devart.com/dotconnect/oracle/download.html (trial version) or from Registered Users' Area (for users with valid subscription only).
For more information, please refer to http://www.devart.com/forums/viewtopic.php?t=23996
Re: [6.80.xxx] OUT VARCHAR2 issue, last char missing?!?
Thank you very much!
I will try soon.
I will try soon.