title: SQLException 00604 & 01003 while calling stored procedure from hibernate named query
body: <p>We are calling a stored procedure ( which calls another inside it) from hibernate.</p>
  
  <p><code>Query query = session.getNamedQuery("query_name");
  query.setParameter('param', 'value');<br>
  query.setResultTransformer(AliasToEntityMapResultTransformer.INSTANCE);
  List returnList = query.list();</code></p>
  
  <p>The stored procedure is independently running good  when we run in SQL developer. But we run this through application it is giving <strong>following error</strong>.</p>
  
  <pre><code>java.sql.SQLException: ORA-00604: error occurred at recursive SQL level 1
  
  ORA-01003: no statement parsed
  </code></pre>
  
  <p><strong>Things we tried :</strong></p>
  
  <ol>
  <li>calling a simple stored procedure from hibernate - working well.</li>
  <li>creating the test case to test the method in which the stored
  procedure (which throws error) is being called - working well.</li>
  </ol>
  
  <p><strong>Our question is</strong> , why the same query is running good in test case, and not while running thorugh application ?</p>
  
  <p>Any ideas?</p>
  
  <p><strong>Update</strong>
  It was my fault, i was passing the arguments in-correctly. Just swapped the first tow arguments. To anybody facing this issue, please check your argument ordering in the named query. </p>
  
  <p>Thanks.</p>