title: Rails execute stored procedure
body: <p>I am trying to execute the <strong>oracle stored procedure</strong> from <strong>rails console</strong>. Using the following code</p>
  
  <pre><code>ActiveRecord::Base.connection.execute("execute change_name('shanison', 'shanison_test');
  </code></pre>
  
  <p>And keep getting the following error</p>
  
  <pre><code>ActiveRecord::StatementInvalid: OCIError: ORA-00900: invalid SQL statement: execute si.change_name('shanison', 'shanison_test');
  </code></pre>
  
  <p>I tried to run the query directly in the <strong>oracle sql developer</strong> and it worked fine, which means <strong>my stored procedure is fine</strong>.</p>
  
  <pre><code>execute change_name('shanison', 'shanison_test');
  </code></pre>
  
  <p>I did grant the Execute permission to the database users that the rails I'm using. I have tried running this under Rails 2 and 3, both doesn't work and shows the same error message.</p>