Begin
Dbms_Rls.Add_Policy(Object_Schema =>'Scott'
,Object_Name =>'T_Policy'
,Policy_Name =>'T_TestPolicy'
,Function_Schema =>'Scott'
,Policy_Function =>'Fn_GetPolicy'
,Statement_Types =>'Select,Insert,Update,Delete'
,Update_Check =>'True'
,Enable =>'True'
);
End;/
第2行初雪错误:
ORA-06550:第2行,第1列
PLS-00201:必须声明标识符'DBMS_RLS'
PL/SQL:Statement ignored谢谢
Dbms_Rls.Add_Policy(Object_Schema =>'Scott'
,Object_Name =>'T_Policy'
,Policy_Name =>'T_TestPolicy'
,Function_Schema =>'Scott'
,Policy_Function =>'Fn_GetPolicy'
,Statement_Types =>'Select,Insert,Update,Delete'
,Update_Check =>'True'
,Enable =>'True'
);
End;/
第2行初雪错误:
ORA-06550:第2行,第1列
PLS-00201:必须声明标识符'DBMS_RLS'
PL/SQL:Statement ignored谢谢
解决方案 »
- 求sql!!!
- PLSQL Developer 和 Oracle
- oracle怎么查后台执行的SQL语句?
- 求教一动态sql的写法,不胜感激!
- 急急!!数据插入问题
- 会的请进!!(oracle9i导入问题)
- 一个SQL语句报错(invalid number)的原因
- 菜菜鸟的一个弱智问题,请高手们帮帮忙
- 用dbstart启动时出现Can't find init file ......请指点!
- 关于if exists .... then ... else... sql 语句在oracle中能否实现的问题!
- 【分享】ORACLE对象名大小写敏感性相关的深入分析
- PowerDesigner与Oracle
前面加个sys.试试?
或者用sys对你当前用户进行下授权