Forum Stats

  • 3,768,568 Users
  • 2,252,811 Discussions
  • 7,874,624 Comments

Discussions

12c is truncating output for varchar2

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;

RokX
This discussion has been closed.