Package oracle.jdbc.driver

Examples of oracle.jdbc.driver.OracleCallableStatement.executeUpdate()

232
233
234
235
236
237
238
239
240
241
242
            // Register the output parameter as cursor.
            cstmt.registerOutParameter(1, oracle.jdbc.driver.OracleTypes.CURSOR);

            // Call the stored procedure to insert the data.
            try {
                cstmt.executeUpdate();

                // If the Procedure node had the IdColumnName attribute set,
                // retrieve the ID value using the column name.
                Console.displayDev("ID column name: ", idColumnName, true, "scb");
View Full Code Here
180
181
182
183
184
185
186
187
188
189
190
        if (ocs != null && article != null) {

            setArticleId(article.getArticleId(), ocs);
            ocs.registerOutParameter(1, oracle.jdbc.driver.OracleTypes.CURSOR);
            ocs.executeUpdate();

            // Get the return value
            rs = ocs.getCursor(1);

            /*
 
View Full Code Here
50
51
52
53
54
55
56
57
58
59
60
      setCreateTime(now, callableStmt);
      setUpdateTime(now, callableStmt);
      setCreateBy("Insert Process", callableStmt);
      setUpdateBy("Insert Process", callableStmt);

      callableStmt.executeUpdate();

      // Get the return value
      rs = callableStmt.getCursor(1);

      // Get id value as integer.
View Full Code Here
109
110
111
112
113
114
115
116
117
118
119
          RelatedPackageCSHelper.ADD_PKG_MAP_SQL);
      callableStmt.registerOutParameter(1, oracle.jdbc.driver.OracleTypes.CURSOR);
      callableStmt.setInt(2, pkgId);
      callableStmt.setInt(3, article.getArticleId());
      callableStmt.setInt(4, BasicArticle.CONTENT_TYPE_ID);
      callableStmt.executeUpdate();
      rs = callableStmt.getCursor(1);
      con.commit();
    }
    finally {
      try {
View Full Code Here
148
149
150
151
152
153
154
155
156
157
158
      callableStmt.registerOutParameter(1, oracle.jdbc.driver.OracleTypes.CURSOR);
      callableStmt.setInt(2, pkgId);
      callableStmt.setInt(3, pkg.getPackageId());
      callableStmt.setInt(4, PhotoPackage.CONTENT_TYPE_ID);
      callableStmt.executeUpdate();
      rs = callableStmt.getCursor(1);
      con.commit();
    }
    finally {
      try {
View Full Code Here
115
116
117
118
119
120
121
122
123
124
125
        }
        setPubDate(ba.getPubDate(), ocs);
        setOverride(1, ocs);

        ocs.registerOutParameter(1, oracle.jdbc.driver.OracleTypes.CURSOR);
        ocs.executeUpdate();
        // Get the return value
        rs = ocs.getCursor(1);

        // Get id value as integer.
        while (rs.next()) {
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.