# 44315
xiaoxiao
|
|
To: 盖老师
create or replace procedure sp_rpt_ContactCampQuery00
(rcursor in out pack_service.t_RetDataSet,
dt_in_begintime in date,
dt_in_endtimein date
 as
err_date exception;
err_data exception;
err_msgvarchar2(500);
begin
open rcursor for
select to_char(accepttime,'yyyy-mm-dd hh24:mi:ss',
decode(t.usersatisfy,'-1','未处理',
1,a.description,
2,a.description,
3,a.description,
4,a.description,
5,a.description,'未知' ,--满意度
calllong --通话时长
from t_tmprpt_contactcampquery t,t_scesmsautogetrulecfg a
where t.usersatisfy = a.content(+);
exception
when others then
rollback;
end;
当我执行上面的脚本时,整个数据库都死掉了,请问盖老师,这是什么原因导致的!
From: xiaoxiao 2009.03.20 03:09
|
|
|
|
# 44312
xiaoxiao
|
|
To:
请问盖老师,怎么样设置以下表空间各参数的值才是最合适的
pctfree:
pctused
initrans
maxtrans
storage
(
initial
next
minextents
maxextents unlimited
pctincrease)
谢谢!
From: xiaoxiao 2009.03.18 02:16
|
|
|
|
|