1 Reply Latest reply on Oct 20, 2016 6:47 AM by Gary Graham-Oracle

    why Oracle SQL Developer can not show clob return values

    user10308940

      DECLARE

        VA1 VARCHAR2(200);

        VA2 VARCHAR2(200);

        v_Return CLOB;

      BEGIN

        v_Return := PCK_ESB_DATA.VF_MATM_DATA(

          VFACT => VA1,

          VMAT => VA2

        );

        /* Legacy output:

      DBMS_OUTPUT.PUT_LINE('v_Return = ' || v_Return);

      */

        :v_Return := v_Return;

      --rollback;

      END;

       

      //Why can not show all data ?

      oracle sql developer.png

       

      PL/SQL developer can show all text values.

      PLSQL.png