0 Replies Latest reply on Apr 2, 2015 11:03 PM by 1051566

    12c is truncating output for varchar2

    1051566

      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;