title: Getting error ORA-22275: invalid LOB locator specified
body: <p>I am new to LOB data type, i am getting error will execute this procedure script as below....</p>
  
  <pre><code>CREATE TABLE SA_ZIP_TEST (
     SEQ          NUMBER,
     STRING_BLOB  BLOB,
     STRING_CLOB  CLOB,
     DT           DATE
  );
  
  CREATE OR REPLACE PROCEDURE ZIP(src IN clob, dst IN OUT NOCOPY BLOB )
  IS
  BEGIN
     IF src is not null THEN
        DBMS_LOB.createtemporary(dst, true, DBMS_LOB.CALL);
        XML_ZIP_PKG_2.ZIP_CLOB(src, dst);
        DBMS_LOB.FREETEMPORARY(dst);
     END IF;
  END ZIP;
  </code></pre>
  
  <p>Will execute the below script getting an error message ORA-22275</p>
  
  <pre><code>DECLARE
     V_Query_Str VARCHAR2 (4000);
     V_RESULT CLOB; 
     V_RESULT2 bLOB;
  BEGIN
     DBMS_LOB.CREATETEMPORARY(V_Result, TRUE, dbms_lob.session);
     FOR I IN 1..100
     LOOP
        V_Query_Str:=
           'INSERT INTO SA_ZIP_TEST
              (seq
              ,DT
              ,STRING_BLOB
              )
           VALUES
              (:Cmd_Seq
              ,:Cmd_DT 
              ,:Result)
        ';
        xml_zip_pkg_2.ZIP(V_Result,V_RESULT2);
        EXECUTE IMMEDIATE V_Query_Str USING I, SYSDATE,V_RESULT2 ;
     END LOOP;
  END;
  </code></pre>