title: dropping a very annoying trigger
body: <p>I am stuck in a very unusal problem. There's one trigger I'd like to drop. Now when I drop it, it is dropped successfully.</p>
  
  <pre><code>drop trigger HRCS.hr_external_salary_in_trigger 
  </code></pre>
  
  <p>But when I run this command then I can see the trigger again:</p>
  
  <pre><code>select * from all_triggers where trigger_name like '%external%'
  </code></pre>
  
  <p>I can see this trigger in UI of PLSQL developer with red x on its head. Now when I try to delete it from left click menu then I get this error:</p>
  
  <pre><code>Error dropping HRCS.hr_external_salary_in_trigger
  ORA-04080: trigger 'HR_EXTERNAL_SALARY_IN_TRIGGER' does not exist
  </code></pre>
  
  <p>Never saw this kind of behavior. Something which I deleted is still there but the program says it doesn't exist while showing it. o_O</p>
  
  <p>How can I get rid of this undesirable annoyance </p>