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
解决方案 »
- sql命令连接符??
- 请问关于ora-12500和ora-12154具体是什么异常
- ----------按时间排序,取前10条数据-------------
- 在AIX5.2上安装ORALCE9I,runInstaller执行后,提示:inventery 目录位置无效
- 各位帮忙看一下这块错在哪里了???
- 我用imp导入方案数据后,视图不可用
- 如何停止oracle的web服务器 servlet
- oracle7.3 和oracle9i 互导出现字符冲突,大家帮忙来看一下!
- 请教一个简单的Update问题
- 监听器的问题
- 各位大佬,快来帮忙吧,Rman备份问题
- 下面oracle自定义函数转换为sql server函数
一定要的话,多试试不同写法,写的简单。
或者用10G。