title: Oracle PL/SQL Trigger asking for binds
body: <p>I'm trying to create my trigger but it's asking for binds EVERY time. It works the way I want it to when I click apply on the window that appears... However, it will log an error... </p>
  
  <p>My trigger checks to see if a client is active or not and do NOT allow changes if it is found to be active... </p>
  
  <pre><code>CREATE Trigger Client_Activity
  BEFORE Insert or Update or Delete ON Client 
  FOR EACH ROW 
  DECLARE
      VAR_AC char(2);
  BEGIN
      IF UPDATING THEN
          SELECT Activity INTO VAR_AC 
          FROM   Client_Additionals 
          WHERE  Activity = :Old.Activity;
  
          IF Activity = 'AC'
              THEN Raise_Application_Error(-20999, 'active')
          END IF; 
  END;
  /
  </code></pre>
  
  <p>ORACLE VERSION 12 USING SQLDEVELOPER</p>