title: Execute Oracle procedure in TOAD
body: <p>I am writing an Oracle procedure using TOAD. I executed the procedure using execute statement. But I am not able to get the result. Instead of that am getting error only. Please help how to run the procedure in TOAD. I am new to toad and Oracle.</p>
  
  <p>Procedure in oracle</p>
  
  <pre><code>create or replace procedure pro_dndtesting( phone number)is 
  begin
  select  FLD_PHONENUMBERS from smsdnd_tbl where FLD_PHONENUMBERS=phone;
  end ;
  /
  </code></pre>
  
  <p>Executing procedure as follows</p>
  
  <pre><code>exec procedure pro_dndtesting(9865015695)
  
  error
  
  ORA-06550: line 1, column 7:
  PLS-00201: identifier 'PRO_DNDTESTING' must be declared
  ORA-06550: line 1, column 7:
  PL/SQL: Statement ignored
  </code></pre>