Do we have a fix for this?
output value is returned as "tr" or "fa"
Related post
http://stackoverflow.com/questions/28508440/microsoft-iis-8-5-oracle-output-variables-are-truncated
I am using the 12c Oracle instant client with enterprise library. It works fine with 11 client.
***********************************
PROCEDURE IsSlateNameExist
(
i_slateId IN VARCHAR2 DEFAULT NULL,
i_slateName IN candidate_slate_tbl.slate_name%TYPE,
o_IsExist OUT VARCHAR2
)
AS
l_count INTEGER := 0;
BEGIN
BEGIN
IF i_slateId IS NULL
THEN
SELECT COUNT (*) INTO l_count FROM cap_wfm.candidate_slate_tbl WHERE slate_name = i_slateName;
IF (l_count > 0)
THEN
o_IsExist := 'true';
ELSE
o_IsExist := 'false';
END IF;
ELSE
SELECT COUNT (*) INTO l_count FROM cap_wfm.candidate_slate_tbl WHERE slate_name = i_slateName AND slate_id <> i_slateId;
IF (l_count > 0)
THEN
o_IsExist := 'true';
ELSE
o_IsExist := 'false';
END IF;
END IF;
END;
END IsSlateNameExist;