存储过程中能否用子查询?
下面是我在存储过程里的一段代码,这段代码在sqlplus里执行没问题,但放在存储过程里时编译时出错:
PLS-00103: Encountered the symbol "SELECT" when expecting one of the following:
( - + mod not null others <an identifier>
<a double-quoted delimited-identifier> <a bind variable> avg
count c
但把select里的两个子查询去掉就不会出错,不知时怎么回事,请高手指点,
多谢!
INSERT INTO BUS_RPT_INTERCALL
SELECT B.CALLERNO,'111',
(select bb.name from BUS_RPT_TAGENTINFO bb
where bb.AGENTID =B.CALLERNO
and bb.SUBCCNO = b.SUBCCNO) ,
B.CALLEENO ,
(select name from BUS_RPT_TAGENTINFO where AGENTID =B.CALLEENO and SUBCCNO = b.SUBCCNO) "CalledName",
B.CALLBEGIN,B.CALLEND,(B.CALLBEGIN - B.CALLEND)*24*3600 "TalkTime",B.SUBCCNO,B.VDN,B.MEDIATYPE
FROM BUS_RPT_BILLLOGTMP B,BUS_RPT_TAGENTINFO T
WHERE B.CALLERNO = TO_CHAR(T.AGENTID(+)) and B.CALLEENO = TO_CHAR(T.AGENTID(+))
AND CALLTYPE = 6 AND MEDIATYPE <> 2;