title: Railo stored procedure in cfscript
body: <p>Does Railo have </p>
  
  <pre><code>&lt;cfscript&gt;
  svc = new storedProc();
  &lt;/cfscript&gt;
  </code></pre>
  
  <p>It looks like there was some discussion about it in <a href="https://groups.google.com/forum/#!topic/railo/Py8R9MtXtSE" rel="nofollow">Google groups</a>.</p>
  
  <p>Edit: </p>
  
  <p>I'm trying this:</p>
  
  <pre><code>&lt;cfscript&gt;
  response = storedproc(procedure="app.GetErrorCodes",result="response",returncode="yes");
  &lt;/cfscript&gt;
  </code></pre>
  
  <p>And am getting "No matching function [STOREDPROC] found"</p>
  
  <p>Edit 2:</p>
  
  <p>This works:</p>
  
  <pre><code>&lt;cfstoredproc procedure="app.GetErrorCodes" debug="yes" result="response" returncode="yes" &gt;
  &lt;/cfstoredproc&gt;
  </code></pre>
  
  <p>Except I don't see a query in the result.</p>
  
  <p>Edit 3:</p>
  
  <p>This works:</p>
  
  <pre><code>&lt;cfscript&gt;
  storedproc procedure="app.GetErrorCodes" result="response" returncode="yes";
  &lt;/cfscript&gt;
  </code></pre>
  
  <p>except I don't see a query inside the result.</p>
  
  <p>Oh wait!  I think I found it!
  <a href="https://groups.google.com/forum/#!msg/railo/UUP0WRuLLX4/zpbKkvekDiAJ" rel="nofollow">https://groups.google.com/forum/#!msg/railo/UUP0WRuLLX4/zpbKkvekDiAJ</a></p>
  
  <p>At last!  Whew!  That only took ALL DAY.</p>