获取oracle Sequence报错

来源:互联网 发布:ubuntu 英文输入法 编辑:程序博客网 时间:2024/06/14 15:55

siebel获取oracle Sequence报错

---------------------------
Siebel
---------------------------
An error has occurred writing to a record.  Please continue or ask your systems administrator to check your application configuration if the problem persists.(SBL-DBC-00111)
ORA-00942: table or view does not exist 
---------------------------
确定   
---------------------------

查询log 报错如下:

SQLParseAndExecute Execute5 0009c38051ff1933:02013-08-07 18:12:10 OCIStmtExecute: DML error or affected 0 rows
ObjMgrBusCompLog Error1 0009c38051ff1933:02013-08-07 18:12:10 (oracon.cpp (3254)) SBL-DBC-00111: An error has occurred writing to a record.

原因:创建Sequence时缺少了grant语句。很低级的错误,可是起初不知道,折腾了半天。
-- Create sequence 
create sequence SIEBEL.HW_CUGID_SEQUENCE
minvalue 1
maxvalue 9999999999
start with 1
increment by 1
nocache;

解决办法:
grant select  on SIEBEL.HW_CUGID_SEQUENCE to sse_role;