public void InitDB(OnChangeEventHandler ev)
        {
            try
            {
                con = new OracleConnection("Data Source=CIS;Password=1111;Persist Security Info=True;User ID=USHO");
                cmd = con.CreateCommand();
                cmd.CommandType = CommandType.Text;
              //  OracleDependency.Port = 1005; 
                dep = new OracleDependency( cmd );
                
                

                cmd.Notification.IsNotifiedOnce = false;
                cmd.AddRowid = true;

                dep.OnChange += ev;
                if(con.State != ConnectionState.Open)
                    con.Open();
                try
                {

                    foreach ( String s in sDs )
                    {
                        cmd.CommandText = String.Format( "SELECT * FROM {0} WHERE ROWNUM < 1", s );
                        try
                        {
                            cmd.ExecuteNonQuery();
                        }
                        catch ( Exception ee )
                        {
                            MessageBox.Show( ee.Message );
                        }
                    }
                }
                finally
                {
                    if ( con.State == ConnectionState.Open )
                        con.Close();
                }
            }
            catch ( Exception e )
            {
                MessageBox.Show( e.Message );
            }

        }

create OR REPLACE function nsi.security_mat ( p_schema in varchar2,p_object in varchar2 )  return varchar2
as
begin
  if( ( user != 'NSI' )AND( user != 'ADM' ) )then
    return 'MAT_HIDE = 0';
  else
    return '1=1';
  end if;
end;

begin
   dbms_rls.add_policy
    ( object_schema   => 'NSI',
      object_name     => 'MATERIAL_WORK',
      policy_name     => 'MAT_POLICY',
      function_schema => 'NSI',
      policy_function => 'security_mat',
      statement_types => 'select',
      update_check    => FALSE );
end;

в Oracle.DataAccess.Client.OracleException.HandleErrorHelper(....) 
в Oracle.DataAccess.Client.OracleCommand.ExecuteNonQuery() 
в TestUshoNotif.dsTableAdapters.MATERIAL_WORKTableAdapter.InitDB(OnChangeEventHandler ev) 
в D:\project\TestUshoNotif\TestUshoNotif\ds.cs:строка 53

 procedure  Tdm.InitNotification;
 var  q:TOraQuery;
    x,i:Integer;
 begin 
    q := TOraQuery.Create(self);
     try 
      q.Connection := ora;
      q.ChangeNotification := OraChange;
      x := Length(ListDS);
       for  i:=  0   to  x - 1   do 
       begin 
       SenMsg(MSG_SPLASH,CLASS_SPLASH, 95 ,Format('Регестрирую: %s',[ListDS[i]]));
       q.SQL.Text := Format('SELECT * FROM %s WHERE ROWNUM < 1',[ListDS[i]]);
        try 
          q.Active := true;
        finally 
          q.Active := false;
        end ;
       end ;
     finally 
      q.Active := false;
      q.Free;
     end ;
 end ;