title: Not able to drop the procedure
body: <p>I have created a function and procedure, the function is called in the procedure. According to the output of the function, in procedure I'm inserting data into some other table. Now that procedure is not executing nor getting dropped. If i try either of them in sql developer or cmd it is running and running with no response from db.</p>
  
  <pre><code>DROP PROCEDURE proc_insert_data;
  </code></pre>
  
  <p>Sql developer was just continuously running there for unlimited time.
  I checked in user_objects and all_objects: Object id is null and it is invalid.</p>