title: Oracle 11g 11.2.0.1 : No more data to read from socket
body: <p>I'm trying to call my function "NUMBERINGMACHINE" by query (SQL> select numberingmachine("param1","param2")from dual;) 
  that contain:</p>
  
  <blockquote>
  <pre><code>create or replace
  function NumberingMachine(numType in varchar2, now in varchar2) return varchar2
  is language java name
  'NumberingMachine.getSequence(java.lang.String, java.lang.String) return java.lang.String';
  </code></pre>
  </blockquote>
  
  <p>and then the function will calling the java class (NumberingMachine class) </p>
  
  <pre><code>public class NumberingMachine {
  
  
  public static String getSequence(String type, String now)  throws SQLException {
  
      /* Connect to database */
  
      Connection conn = new OracleDriver().defaultConnection();
      conn.setAutoCommit(false);
  
      /* construct dynamic sql */
  
      String selectSql = "SELECT NUMVALUE,NUMLEN,UPDTYPE,UPDDATE FROM M_SEQUENCE WHERE NUMTPCD = ? FOR UPDATE";
      String updateSql = "UPDATE M_SEQUENCE SET NUMVALUE=?, UPDDATE=? WHERE NUMTPCD = ?";
  </code></pre>
  
  <p>but i get error:
  no more data to read from socket . </p>
  
  <p>does anyone have the solution?</p>
  
  <p>my oracle sql  developer version:</p>
  
  <blockquote>
    <p>SELECT * FROM V$VERSION</p>
  </blockquote>
  
  <p>Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production</p>
  
  <p>PL/SQL Release 11.2.0.1.0 - Production
  "CORE   11.2.0.1.0  Production"</p>
  
  <p>TNS for 32-bit Windows: Version 11.2.0.1.0 - Production</p>
  
  <p>NLSRTL Version 11.2.0.1.0 - Production</p>