title: Check ID Exist and delete record in PL SQL
body: <p>What I have to do is, whenever a <code>STORE_CODE</code> is entered it will check in the db and delete the store code. SO for that, I have written a procedure which is as below</p>
  
  <pre><code>PROCEDURE DELETE_STORE_INFO
  (
    P_STORE_CODE IN NVARCHAR2
  )
  
    AS
  
      BEGIN
  
      UPDATE TBL_RRSOC_STORE_INFO set ISACTIVE = 'N' where STORE_CODE = P_STORE_CODE;
  
      END DELETE_STORE_INFO;
  </code></pre>
  
  <p>But here what missing is</p>
  
  <blockquote>
    <p>what if the user enter the wrong <code>store_code</code> and does the operation so what it will do. how to check with that part ?</p>
  </blockquote>
  
  <p>I guess something for <code>COUNT</code> wont work at this stage. Kindly suggest</p>