title: "PL/SQL: Statement ignored" error in Java
body: <p>When I call a PL/SQL of particular schema in Java file it is getting executed and retrieves the result. But when I call another PLSQL in the same Java file of different schema it shows an error saying:  </p>
  
  <pre><code>Message: `ORA-06550: line 1, column 7: PLS-00201: identifier 'TEST2' must be declared ORA-06550: line 1, column 7: PL/SQL: Statement ignored` 
  </code></pre>
  
  <p>Example : There are two proc say A and B present in x schema and y schema</p>
  
  <p>I am calling it under test.java file:</p>
  
  <pre><code>CallableStatement csforST= connection.prepareCall("{ call A() }"); 
  csforST.execute();
  </code></pre>
  
  <p>It works fine.</p>
  
  <p>But when I call:</p>
  
  <pre><code>CallableStatement cs= connection.prepareCall("{ call B() }"); 
  cs.execute();
  </code></pre>
  
  <p>It displays an error saying B must be declared.</p>