以下步骤供参考:

1步： 搭建测试环境

SQL> create table t1 (id int,loc clob);

Table created.

SQL> insert into t1 values(1,to_clob(‘Oracle’));

1 row created.

SQL> commit;

2步： 创建带CLOB输入参数的存储过程

SQL> create or replace procedure proc_t1(v_loc in clob)
2 as
3 v_id int;
4 begin
5 select count(*) into v_id from t1 where dbms_lob.instr(loc, v_loc) > 0;
6 end;
7 /

Procedure created.

3步：

将CLOB 类型的入参存入一张测试表的CLOB类型的字段中，
然后通过PL/SQL块，将此参数取出并以入参传入指定存储过程

SQL> declare
2 n_loc clob;
3 begin
4 select loc into n_loc from t1 where id=1;
5 proc_t1(v_loc=>n_loc);
6 end;
7 /

PL/SQL procedure successfully completed.

SQL>