oracle Wrap 问题求解
update temp_AGENT_ASSESSMENT_TARGETS
set CALL_TIME_SCORE = round(((CALL_TIME-(select avg(CALL_TIME)
from temp_AGENT_ASSESSMENT_TARGETS)
) /
(((select max(CALL_TIME)
from temp_AGENT_ASSESSMENT_TARGETS) -
(select min(CALL_TIME)
from temp_AGENT_ASSESSMENT_TARGETS)) / 30) * 0.1 + 4),
1)
where CALL_TIME >=
(select avg(CALL_TIME) from temp_AGENT_ASSESSMENT_TARGETS);
这段程序在Package中运行时没有问题的,但是wrap的时候却不能通过
9I下面Wrap编译错误信息:
PL/SQL Wrapper: Release 9.2.0.1.0- Production on Fri Mar 21 16:05:58 2008Copyright (c) Oracle Corporation 1993, 2001. All Rights Reserved.Processing bbase.sql to bbase.plb
PSU(103,1,12701,42):Encountered the symbol "SELECT" when expecting one of the fo
llowing: ( - + case mod new not null others <an identifier>
<a double-quoted delimited-identifier> <a bind variable> avg
count current exists max min prior sql stddev sum variance
execute forall merge time timestamp interval date
<a string literal with character set specification>
<a number> <a single-quoted SQL string> pipe
update temp_AGENT_ASSESSMENT_TARGETS
set CALL_TIME_SCORE = round(((CALL_TIME-(select avg(CALL_TIME)
from temp_AGENT_ASSESSMENT_TARGETS)
) /
(((select max(CALL_TIME)
from temp_AGENT_ASSESSMENT_TARGETS) -
(select min(CALL_TIME)
from temp_AGENT_ASSESSMENT_TARGETS)) / 30) * 0.1 + 4),
1)
where CALL_TIME >=
(select avg(CALL_TIME) from temp_AGENT_ASSESSMENT_TARGETS);
这段程序在Package中运行时没有问题的,但是wrap的时候却不能通过
9I下面Wrap编译错误信息:
PL/SQL Wrapper: Release 9.2.0.1.0- Production on Fri Mar 21 16:05:58 2008Copyright (c) Oracle Corporation 1993, 2001. All Rights Reserved.Processing bbase.sql to bbase.plb
PSU(103,1,12701,42):Encountered the symbol "SELECT" when expecting one of the fo
llowing: ( - + case mod new not null others <an identifier>
<a double-quoted delimited-identifier> <a bind variable> avg
count current exists max min prior sql stddev sum variance
execute forall merge time timestamp interval date
<a string literal with character set specification>
<a number> <a single-quoted SQL string> pipe
一定要的话,多试试不同写法,写的简单。
或者用10G。