title: How to find out if this SELECT query executed successfully?
body: <pre><code> CREATE PROCEDURE Pname(in_empno IN NUMBER out_name OUT VARCHAR2)
   AS
   BEGIN
   select EmpName into out_name from emptable where Empno = in_empno;
   END Pname;
  </code></pre>
  
  <p>In the above procedure, how can I check if the SELECT query executed successfully or not with the given condition?</p>