pl/sql sql Oracle DRA-01008并非所有变量都已绑定

Question

这个大佬能看看这中间有什么毛病嘛

这边是我的sql语句

 Select a.*
  From (select /*+first_rows*/
         wi.iid as 顺序号,
         w.wname as 案件类型,
         i.name as 名称,
         x.联系人 as 联系人,
         wi.accepted_time as 接收时间,
         wi.submit_time as 提交时间,
         (Select user_name From st_user Where userid = wi.senduserid) as 前一用户,
         wi.wiid,
         wi.step as 所在岗位,
         x.业务类型id as BusinessId
          from ST_WORK_ITEM_HIST wi,
               xt_instance       x,
               st_instance       i,
               st_workflow       w
         where wi.iid = x.iid
           and x.iid = i.iid
           and i.wid = w.wid
           and wi.userid = :userId
           and x.业务类型id in
               (select id from sys_business_type b where b.type = :type)
         order by wi.accepted_time desc) a
 Where rownum <= 10

Answer 1

type这个变量在哪里定义的？

(select id from sys_business_type b where b.type = :type)
换成具体的值，不用type变量看看是否报错。