Package java.sql

Examples of java.sql.CallableStatement.registerOutParameter()


      oCall.registerOutParameter(10, Types.VARCHAR); // id_status
      oCall.registerOutParameter(11, Types.VARCHAR); // path_metadata
      oCall.registerOutParameter(12, Types.VARCHAR); // tx_comments
      oCall.registerOutParameter(13, Types.CHAR);    // gu_company
      oCall.registerOutParameter(14, Types.CHAR);    // gu_project
      oCall.registerOutParameter(15, Types.VARCHAR); // tx_email_from
      oCall.registerOutParameter(16, Types.VARCHAR); // tx_email_reply
      oCall.registerOutParameter(17, Types.VARCHAR); // nm_from
      oCall.registerOutParameter(18, Types.VARCHAR); // tx_subject

      if (DebugFile.trace) DebugFile.writeln("CallableStatement.execute()");
View Full Code Here


      oCall.registerOutParameter(11, Types.VARCHAR); // path_metadata
      oCall.registerOutParameter(12, Types.VARCHAR); // tx_comments
      oCall.registerOutParameter(13, Types.CHAR);    // gu_company
      oCall.registerOutParameter(14, Types.CHAR);    // gu_project
      oCall.registerOutParameter(15, Types.VARCHAR); // tx_email_from
      oCall.registerOutParameter(16, Types.VARCHAR); // tx_email_reply
      oCall.registerOutParameter(17, Types.VARCHAR); // nm_from
      oCall.registerOutParameter(18, Types.VARCHAR); // tx_subject

      if (DebugFile.trace) DebugFile.writeln("CallableStatement.execute()");
View Full Code Here

      oCall.registerOutParameter(12, Types.VARCHAR); // tx_comments
      oCall.registerOutParameter(13, Types.CHAR);    // gu_company
      oCall.registerOutParameter(14, Types.CHAR);    // gu_project
      oCall.registerOutParameter(15, Types.VARCHAR); // tx_email_from
      oCall.registerOutParameter(16, Types.VARCHAR); // tx_email_reply
      oCall.registerOutParameter(17, Types.VARCHAR); // nm_from
      oCall.registerOutParameter(18, Types.VARCHAR); // tx_subject

      if (DebugFile.trace) DebugFile.writeln("CallableStatement.execute()");

      oCall.execute();
View Full Code Here

      oCall.registerOutParameter(13, Types.CHAR);    // gu_company
      oCall.registerOutParameter(14, Types.CHAR);    // gu_project
      oCall.registerOutParameter(15, Types.VARCHAR); // tx_email_from
      oCall.registerOutParameter(16, Types.VARCHAR); // tx_email_reply
      oCall.registerOutParameter(17, Types.VARCHAR); // nm_from
      oCall.registerOutParameter(18, Types.VARCHAR); // tx_subject

      if (DebugFile.trace) DebugFile.writeln("CallableStatement.execute()");

      oCall.execute();
View Full Code Here

      else {
        if (DebugFile.trace) DebugFile.writeln("{call k_sp_get_cat_path ('" + getStringNull(DB.gu_category, "null") + "',?)}");

        oCall = oConn.prepareCall("{call k_sp_get_cat_path (?,?)}");
        oCall.setString(1, getString(DB.gu_category));
        oCall.registerOutParameter(2, java.sql.Types.VARCHAR);
        oCall.execute();
        sPath = oCall.getString(2);
        oCall.close();
      }
    // End SQLException
View Full Code Here

      if (DebugFile.trace) DebugFile.writeln("Connection.prepareCall({ call k_sp_cat_usr_perm('" + sIdUser + "','" + getStringNull(DB.gu_category,null) + "',?) })");

      oCall = oConn.prepareCall("{ call k_sp_cat_usr_perm(?,?,?) }");
      oCall.setString(1, sIdUser);
      oCall.setString(2, getString(DB.gu_category));
      oCall.registerOutParameter(3, java.sql.Types.INTEGER);
      oCall.execute();
      iACLMask = oCall.getInt(3);
      oCall.close();
    }
View Full Code Here

      if (DebugFile.trace) DebugFile.writeln("Connection.prepareCall({ call k_sp_cat_grp_perm('" + sIdGroup + "','" + getStringNull(DB.gu_category,null) + "',?) })");

      oCall = oConn.prepareCall("{ call k_sp_cat_grp_perm(?,?,?) }");
      oCall.setString(1, sIdGroup);
      oCall.setString(2, getString(DB.gu_category));
      oCall.registerOutParameter(3, java.sql.Types.INTEGER);
      oCall.execute();
      iACLMask = oCall.getInt(3);
      oCall.close();
    }
View Full Code Here

      oStmt.close();
    }
    else {
      oCall = oConn.prepareCall("{ call k_sp_cat_level(?,?)}");
      oCall.setString(1, getString(DB.gu_category));
      oCall.registerOutParameter(2, java.sql.Types.INTEGER);
      oCall.execute();
      iLevel = oCall.getInt(2);
      oCall.close();
    }
View Full Code Here

        break;
      default:
        if (DebugFile.trace) DebugFile.writeln("Connection.prepareCall({ call k_sp_get_user_mailroot('"+getStringNull(DB.gu_user,"null")+"',?) }");
        oCall = oConn.prepareCall("{ call k_sp_get_user_mailroot(?,?) }");
        oCall.setString(1, getString(DB.gu_user));
        oCall.registerOutParameter(2, java.sql.Types.CHAR);
        oCall.execute();
        sRetVal = oCall.getString(2);
        oCall.close();
        break;
    }
View Full Code Here

      default:
        if (DebugFile.trace) DebugFile.writeln("Connection.prepareCall({ call k_sp_get_user_mailfolder('"+getStringNull(DB.gu_user,"null")+"','"+sFolderName+"',?)})");
        oCall = oConn.prepareCall("{ call k_sp_get_user_mailfolder(?,?,?) }");
        oCall.setString(1, getString(DB.gu_user));
        oCall.setString(2, sFolderName);
        oCall.registerOutParameter(3, java.sql.Types.CHAR);
        oCall.execute();
        sRetVal = oCall.getString(3);
        oCall.close();
        break;
    }
View Full Code Here

TOP
Copyright © 2018 www.massapi.com. All rights reserved.
All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.