PreparedStatement stmt = connection.prepareStatement
          (" INSERT INTO textBook ( Titletheme, Parentunitid , Textbooktypeid ) "
          +" VALUES (?,TO_NUMBER(?),TO_NUMBER(?)) ");
          stmt.setString( 1 ,sTitleTheme);     // Bind the textBook.titleThem       Input parameter
          stmt.setString( 2 ,sParentUnitID);   // Bind the textBook.sParentUnitID   Input parameter
          stmt.setString( 3 ,sTextBookTypeID); // Bind the textBook.sTextBookTypeID Input parameter
          stmt.executeQuery();
          
PreparedStatement stmtSeqNumber = connection.prepareStatement
          ("select SQ_TEXTBOOK.CURRVAL from DUAL");
ResultSet rset = stmtSeqNumber.executeQuery();
           while  (rset.next()) 
          {
          sTextBookID=(String).valueOf(rset.getInt( 1 ));
          }
          
          System.out.println("Working textBook.teorUnitInsert(String , String, String) ");//trace