17,090
社区成员
发帖
与我相关
我的任务
分享怎么在SP中create sequence?
写了一个如下的SP：
create or replace procedure CREATESQ_TEST(P_CHECK OUT VARCHAR2) is
v_count int;
begin
SELECT COUNT(*) INTO v_count FROM USER_SEQUENCES u WHERE u.sequence_name='SQ_TEST_NO';
if v_count > 0 then
EXECUTE IMMEDIATE 'DROP SEQUENCE SQ_TEST_NO';
end if;
EXECUTE IMMEDIATE 'create sequence SQ_TEST_NO minvalue 0 maxvalue 99999 start with 1 increment by 1 nocache'; --报错，ORA-01031 - insufficient privileges
end BES_CREATESQ_TEST;
create or replace procedure CREATESQ_TEST(P_CHECK OUT VARCHAR2) is
v_count int;
begin
SELECT COUNT(*) INTO v_count FROM USER_SEQUENCES u WHERE u.sequence_name='SQ_TEST_NO';
if v_count > 0 then
EXECUTE IMMEDIATE 'DROP SEQUENCE SQ_TEST_NO';
end if;
EXECUTE IMMEDIATE 'create sequence SQ_TEST_NO minvalue 0 maxvalue 99999 start with 1 increment by 1 nocache'; --报错，ORA-01031 - insufficient privileges
end BES_CREATESQ_TEST;
...全文
请发表友善的回复…
发表回复
shine333 2003-12-04
- 打赏
- 举报
存储过程中的权限要另外设置的
jupiterII 2003-12-03
- 打赏
- 举报
我直接RUN create的语句是执行的啊。而且他也能DROP，为什么就不能CREATE呢？
ruyuezhang 2003-12-03
- 打赏
- 举报
看一下有没有create sequence的权限。
