title: How to check if a stored procedure exist?
body: <p>I have searched the net and I've found a <a href="http://newsgroups.derkeiler.com/Archive/Comp/comp.databases.oracle.server/2005-07/msg00386.html">post</a> that uses the following snippet to check if a stored procedure exists:</p>
  
  <pre><code>select * 
    from USER_SOURCE 
   where type='PROCEDURE' 
     and name='my_stored_procedure.' 
  </code></pre>
  
  <p>Is there any other way to check if a procedure exists?</p>
  
  <p><strong>Edited to add:</strong></p>
  
  <p>Before posting SQL Server ways, please I'm looking for ORACLE ways.</p>