为什么在SQL里能正常运行的语句,写在存储过程就报错??
错误信息Error: ORA-00937: not a single-group group function
ORA-06512: at line 1, Batch 1 Line 1 Col 1
错误信息Error: ORA-00937: not a single-group group function
ORA-06512: at line 1, Batch 1 Line 1 Col 1
解决方案 »
- oracle 10 g 出现table or view does not exist
- oracle 行转列的问题
- oracle中怎样比较两个库中是否有重名的数据表.
- 使用单值函数power时出错,高手请赐教
- 初学的疑问?
- 利用prepareCall执行数据库存储过程时,如何接受多个输出参数?
- 初学oracle看到书上关于包有这么一句话不理解什么意思
- 第一次装oracle9i就遇到奇怪问题:最后自动配置工具(database configuration assistant)时,既不报错,进程也没死,但就是不往前走了!
- 小问题!!!!
- 哪里有oracle9ias下载?
- 急问JOB问题
- 重装Oracle失败的问题,谢谢
应该是你把sql赋给一个变量,但sql的返回不知一条所致出错。
delete from dw.dw_ghlx where state_date = rq;
commit;
insert into dw.dw_ghlx
(state_date, count, exch_id, main_prod_id, main_spec_id, prod_id)
select state_date,
sum(a.count),
exch_id,
main_prod_id,
main_spec_id,
prod_id
from dw.dw_wxz_xyw_ddl a
where state_date = rq
group by state_date, exch_id, main_prod_id, main_spec_id, prod_id;
commit;
end;
这段代码,在SQL里把RQ换成'YYYYMMDD'可以正常运行,写存储过程里就报错,我改了一下,现在报这个错误:
Error: ORA-00978: nested group function without GROUP BY
ORA-06512: at line 1, Batch 1 Line 1 Col 1;
麻烦高手帮忙看看谢谢~
delete from dw.dw_wxz_zyyh_ddl
where state_date=rq;
commit;
insert into dw.dw_wxz_zyyh_ddl(state_date,count,exch_id,prod_id,COMM_SERV_SPEC_ID)
select to_char(stat_date,'yyyymmdd'),sum(amount),exch_id,prod_id,COMM_SERV_SPEC_ID
from JLCNCNEW97.rept_yy_zyyh@new97
where local_net_id=431
and to_char(stat_date,'yyyymmdd')=rq
GROUP BY to_char(stat_date,'yyyymmdd'),exch_id,prod_id,COMM_SERV_SPEC_ID;
commit;