收到错误ORA-22275:指定了无效的LOB定位器 [英] Getting error ORA-22275: invalid LOB locator specified

问题描述

我是LOB数据类型的新手，我遇到错误将执行以下过程脚本....

I am new to LOB data type, i am getting error will execute this procedure script as below....

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;

将执行以下脚本，得到一条错误消息ORA-22275

Will execute the below script getting an error message ORA-22275

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;

推荐答案

V_RESULT2由于ZIP

这篇关于收到错误ORA-22275:指定了无效的LOB定位器的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！