title: Error When Accessing plsql function: invalid name pattern
body: <p>I have a function which returns array and I am calling this function from java to get the values.</p>
  
  <p>PL/SQL Code</p>
  
  <pre><code>create or replace type dates
         is array(10000) of varchar2(32)
  </code></pre>
  
  <p>function</p>
  
  <pre><code>CREATE OR REPLACE function datefunc (    
      id1    IN number,
      id2    IN NUMBER    
  
  )
      RETURN dates
  AS
      datearray          dates;
      sdate       VARCHAR2 (32);
      edate       VARCHAR2 (32);
  BEGIN
  </code></pre>
  
  <p>Java code</p>
  
  <pre><code>     connection = datacon.getConnection();
                      callablestatement = 
      connection.prepareCall("begin ? :=datefunc(?,?,?); end;");
                      callablestatement.registerOutParameter
  (1, OracleTypes.ARRAY,"dates");
                      callablestatement.setInt(2, param1);
                      callablestatement.setInt(3, param2);
                      callablestatement.execute();
  </code></pre>
  
  <p>But when I execute my code I am getting</p>
  
  <pre><code>java.sql.SQLException: invalid name pattern: schema.dates
  </code></pre>
  
  <p>What could be the reason for this and how can I resolve this error?</p>
  
  <p>Thanks</p>