Windows Oracle Data Access Components (MOSC)

MOSC Banner

Is this a bug with Entity Framework to oracle?

edited Mar 15, 2011 5:00AM in Windows Oracle Data Access Components (MOSC) 1 commentAnswered
 Hi, I'm using Entity Framework beta version.


At first,I opened audit with sysdba on oracle database.

I write a procedure:

create or replace procedure auditUser(auditUser in varchar2,oper in int) 
is 
policyName varchar2(2000); 
policynum varchar2(20); 
cursor tables is select object_name from dba_objects where owner=auditUser and object_type='TABLE';
begin 
for tableName in tables loop 
begin 
policynum := 'AUDIT1_'; 
policyName := concat(policynum,tableName.Object_Name); 
if oper=1 then 
dbms_fga.add_policy(object_schema=>auditUser,object_name=>tableName.Object_Name,policy_name => policyName,
statement_types=>'select,insert,update,delete',enable=>true); 
end if; 
if oper=0 then

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center