0 Replies Latest reply on Jan 29, 2014 7:35 PM by siromega

    Providing a long CLOB in PL/SQL Debugging

    siromega

      I am debugging a PL/SQL procedure in SQL Developer 4. One of the parameters to the PL/SQL function is a CLOB. I am attempting to figure out how to setup the CLOB for a 51,000+ character CLOB. However I get a "string literal too long" error message.


      DECLARE

        P_XMLSTRING CLOB;

        P_RESULT_CURSOR sys_refcursor;

      BEGIN

        P_XMLSTRING := NULL;

       

        MyPackage.CREATEDOCUMENT(

          P_XMLSTRING => P_XMLSTRING,

          P_RESULT_CURSOR => P_RESULT_CURSOR

        );

      END;

       

      I've tried to set P_XMLSTRING in various ways - plain single quotes ('abc 123'), using TO_CLOB(), creating new temporary clobs using DBMS_LOB, etc. and I cant seem to get it working.