title: no statement parsed and wrong number or types of arguments - cfstoredproc
body: <p>I have an Oracle procedure - editBacklog which I'm calling from a CFM page via cfstoredproc.  After several <strong>changes to the procedure</strong> I started getting <strong>ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments in call to 'EDITBACKLOG'</strong>.  I've gotten this before and found that if I changed the name of the procedure it starts working again.  I changed the name to editBacklog2 and it worked as I expected it to.  I changed the name back to editBacklog and got the same error.  I changed the name back to editBacklog2 again and started getting <strong>ORA-01003: no statement parsed</strong>.  NOTHING has changed at this point except for the names.  I changed the name yet again to editBacklog3 and it works as expected.</p>
  
  <p>As of right now<br>
  editBacklog = ORA-06550<br>
  editBacklog2 = ORA-01003<br>
  editBacklog3 = works (kinda)</p>
  
  <p>This whole thing started when I was trying to fix an ORA-01821: date format not recognized error.  I fear when I start changing things I'll start getting the same lame behavior described above.</p>
  
  <p>Either Oracle or CF is messing with me and I'll end up liking one of them less because of it.</p>
  
  <p>I assume it's probably cfstoredproc caching metadata or something but neither google, livedocs, or OTN have much to say about my situation.</p>
  
  <p>I'm not the SA or DBA.</p>
  
  <p>Anyone have any ideas?</p>