40     String driverName = "oracle.jdbc.driver.OracleDriver";
     41     Class.forName(driverName).newInstance();
     42     
     43       Connection conn = null;
     44       String connStr = //connection string;
     45       String username = //user
     46       String password = //pass
     47       
     48       Properties props = new Properties();
     49 
     50       props.put("user", username );
     51       props.put("password", password);
     52       props.put("SetBigStringTryClob", "true");
     53       
     54       ResultSet rs = null;
     55       String realQ = generateQuery(query);
     56       
     57      //for(int i=0; i<100; i++){
     58 
     59       // Create the database connection, if it is closed.
     60       if ((conn==null)||conn.isClosed())
     61         conn = DriverManager.getConnection( connStr, props );
     62       
     63      String thetext=null;
     64      for(int i=0; i<1; i++){ //this is for testing, currently does nothing
     65      
     66      //PreparedStatement pstmt = null;
     67      CallableStatement cstmt = null;
     68      
     69      cstmt = conn.prepareCall("{? = call markup_document(?,?)}");
     70      cstmt.registerOutParameter(1, java.sql.Types.CLOB);
     71      cstmt.setString(2,realQ);
     72      cstmt.setString(3,docno);
     73      cstmt.execute();     
     76      Clob mklob = cstmt.getClob(1);
     77      
     78      thetext = (mklob.getSubString(1,(int)mklob.length()));
     79      cstmt.close();
     80      }
     81      conn.close();
     82      System.out.println(thetext);