PLS-306: wrong number or types of arguments in call to 'OGC_X'

[size=medium] 今天写一个sql插入的时候出现了一个异常：PLS-306: wrong number or types of arguments in call to 'OGC_X'。上网找了找，发现一个真理：幸福的人都一样，不幸的人各有各的不幸。[/size]
[size=medium]于是自己好好研究了一下自己的sql：[/size]

select *
       from (select a.agent_code agent_code,
               a.user_name user_name,
               c.name sub_company,
               d.agent_level || '级' agent_level,
               (case when 
              ( select x.check_state
                 from vzzjzgl_apply x
                where x.agent_code = a.agent_code ) = '01'
                then trim('已授权')
                 else trim('未授权')
                     end) is_grant,

              (select xxx.grant_time
                         from vzzjzgl_apply xxx
                        where xxx.agent_code = a.agent_code)  operate_time,
                         (case when (select x.operator
                                 from vzzjzgl_apply xxxx
                                where xxxx.agent_code = a.agent_code
                                ) is not null then (select x.operator
                                 from vzzjzgl_apply xxxx
                                where xxxx.agent_code = a.agent_code) 
                                else '---' end ) operator

                                  from
                                                agent_agent a
                                                inner join party c on a.organ_code = c.id
                                                inner join agent_level d on a.agent_level_code =
                                                                            d.agent_level_code)

      where 1 = 1
      order by agent_code

[size=medium]不知道聪明细心的你有没有发现我的马大哈错误呢，仔细看看选择operator那段，知道原因了吧？我将vzzjzgl_apply的简称xxxx写成x了。
写下来只是告诉大家一声大概就是这样的毛病。希望我们以后都不要再犯。呵呵。[/size]