create or replace procedure wallet(status in varchar2) return varchar2 as l_result number;
l_data varchar2(100);
begin
select status into l_data from v$encryption_wallet;
case l_data
when 'OPEN' then
dbms_output.put_line('OPEN');
when 'CLOSED' then
EXECUTE IMMEDIATE 'alter system set wallet open identified by "tddj"';
end case;
return status;
end wallet;
测试到执行alter语句的时候提示权限不足,单独把alter语句提出来就能执行,怎么解决
l_data varchar2(100);
begin
select status into l_data from v$encryption_wallet;
case l_data
when 'OPEN' then
dbms_output.put_line('OPEN');
when 'CLOSED' then
EXECUTE IMMEDIATE 'alter system set wallet open identified by "tddj"';
end case;
return status;
end wallet;
测试到执行alter语句的时候提示权限不足,单独把alter语句提出来就能执行,怎么解决
解决方案 »
- bat并发执行sqlldr命令,并监控完成状态的问题
- Oracle字符集
- 哪位大虾帮我看看数据库的参数设置是否合理?
- 关于Oracle中无限级分类的查询问题
- m_pConnection->Execute((_bstr_t)sql,&vtMissing,adCmdText);报运行错误,如何解决
- 功能统计!
- oracle如何实现这种功能,一个部门表有部门编码,一个员工表有部门编码
- 这一段时间没来了,发现突然长了三个星星,:) 祝大家元旦快乐!
- 怎样在SQL语句中把当前时间和字段里的时间进行比较?
- 关于在前台程序里面建ORACLE的JOB???高手请进
- 游标问题
- oracle账户被锁定都有什么原因导致
l_result number;
l_data varchar2(100);
begin
select status into l_data from v$encryption_wallet;
case l_data
when 'OPEN' then
dbms_output.put_line('OPEN');
when 'CLOSED' then
EXECUTE IMMEDIATE 'alter system set wallet open identified by "tddj"';
end case;
return status;
end wallet1;
上面代码贴错了 这个才是