procedure test_insert_blob(p_id number) is
  v_data_blob  Blob;
  temp varchar(5000);
begin

select '111' into v_data_blob from dual;

  INSERT  INTO test_blob VALUES( p_id , v_data_blob );

end test_insert_blob;

服务器是什么版本的?

------解决方案--------------------

执行不了，报什么错误？
如果是字符串类型的话，用 clob 更好一点
探讨

SQL code

procedure test_insert_blob(p_id number) is
  v_data_blob  Blob;
  temp varchar(5000);
begin

select '111' into v_data_blob from dual;

  INSERT  INTO test_blob VALUES( p_id , v_data_blob );……