菜鸟有存储过程问题请教各位

[小小大麦]

在存储过程中,有下面一段代码:
V_SQL11 := 'SELECT COUNT(1)
INTO V_NUMBERS
FROM T_C_SR_REFUNDCONTROLCONFIG T
WHERE T.DELFLAG = ''0''
AND EXISTS (SELECT 1
FROM T_C_PBH_RELATEBUSSINESSTYPE T2
WHERE T.TYPEID = T2.REPAYBUSSINESSTYPE
AND T2.CITYNAME LIKE ''%' || I_CITY || '%''
AND T2.ISENABLE = ''Y''
AND T2.SRTYPEID = ' || '''' || I_SRTYPEID || '''' || '
AND T2.PROBLEMTYPE = ' || '''' || I_PBHCLASS || '''' || ')
AND T.CITY LIKE ''%' || I_CITY || '%''
AND T.VALIDITY = ''1''';
EXECUTE IMMEDIATE V_SQL11;

但这段代码第二行报错，说缺失关键字，把变量代入后如下：
SELECT COUNT(1)
INTO V_NUMBERS
FROM T_C_SR_REFUNDCONTROLCONFIG T
WHERE T.DELFLAG = '0'
AND EXISTS (SELECT 1
FROM T_C_PBH_RELATEBUSSINESSTYPE T2
WHERE T.TYPEID = T2.REPAYBUSSINESSTYPE
AND T2.CITYNAME LIKE '%广州%'
AND T2.ISENABLE = 'Y'
AND T2.SRTYPEID = '006043003002010'
AND T2.PROBLEMTYPE = '14001')
AND T.CITY LIKE '%广州%'
AND T.VALIDITY = '1'

到底为什么缺失关键字呢,请好心人帮忙解答,因为这个存储过程公司催得我很急,可以的话帮我修改一下SQL,谢谢了

[蓝色蛋饼]

sql中不要into execute immediate v_sql into v_numbers 参考如下 http://www.itpub.net/thread-1869795-1-1.html

[jdsnhan]

execute immediate into .... using ..... 结果用into，变量用using

[小小大麦]

引用 1楼蓝色蛋饼 的回复:

sql中不要into execute immediate v_sql into v_numbers 参考如下 http://www.itpub.net/thread-1869795-1-1.html

真心感谢

[小小大麦]

引用 2楼jdsnhan 的回复:

execute immediate into .... using ..... 结果用into，变量用using

真心感谢