Package oracle.jdbc.driver

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

228
229
230
231
232
233
234
235
236
237
238
                                                   strDescriptor);

            } // End of loop through Param elements

            // 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();
View Full Code Here
179
180
181
182
183
184
185
186
187
188
189
        ocs = (OracleCallableStatement) con.prepareCall(GET_ARTICLE_URLS_SQL);

        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
33
34
35
36
37
38
39
40
41
42
43
    ResultSet rs = null;
    try {
      ocs = (OracleCallableStatement) con.prepareCall(INSERT_MAP_SQL);

      if (ocs != null) {
        ocs.registerOutParameter(1, oracle.jdbc.driver.OracleTypes.CURSOR);
        setContentTypeId(cm.getContentTypeId(), ocs);
        setArticleId(articleId, ocs);
        setCategoryId(0, ocs);
        setRank(999, ocs);
        setUserName(cm.getUserName(), ocs);
View Full Code Here
49
50
51
52
53
54
55
56
57
58
59
        setAdminThumbnail(photo.getAdminThumbnail(), ocs);
        setNeedsResize(photo.needsResize(), ocs);
        // @todo: Can we get the resize info from the feed?
        setResizeImageSize(0, ocs);

        ocs.registerOutParameter(1, java.sql.Types.INTEGER);
        ocs.execute();
        // Get id value as integer.
        photoID = ocs.getInt(1);
        con.commit();
      }
View Full Code Here
39
40
41
42
43
44
45
46
47
48
49
    try {
      callableStmt = (OracleCallableStatement) con.prepareCall(
          RelatedPackageCSHelper.INSERT_PKG_SQL);

      Date now = java.util.Calendar.getInstance().getTime();
      callableStmt.registerOutParameter(1, oracle.jdbc.driver.OracleTypes.CURSOR);
      setPackageId(0, callableStmt);
      setPackageDesc(getPackageDescFromPackage(cp), callableStmt);
      setSiteId(cp.getSiteId(), callableStmt);
      setPubId(cp.getPubId(), callableStmt);
      setStatus(1, callableStmt);
View Full Code Here
105
106
107
108
109
110
111
112
113
114
115
    OracleCallableStatement callableStmt = null;
    ResultSet rs = null;
    try {
      callableStmt = (OracleCallableStatement) con.prepareCall(
          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);
View Full Code Here
144
145
146
147
148
149
150
151
152
153
154
    ResultSet rs = null;
    try {
      callableStmt = (OracleCallableStatement) con.prepareCall(
          RelatedPackageCSHelper.ADD_PKG_MAP_SQL);

      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);
View Full Code Here
42
43
44
45
46
47
48
49
50
51
52
          setCategoryId(photoPkg.getCategoryId(), ocs);
          setStartTime(photoPkg.getStartTime(), ocs);
          setEndTime(photoPkg.getEndTime(), ocs);
          setKeywords(photoPkg.getKeywords(), ocs);

          ocs.registerOutParameter(1, java.sql.Types.INTEGER);
          ocs.execute();
          // Get id value as integer.
          photoPkgId = ocs.getInt(1);
        }
        con.commit();
View Full Code Here
114
115
116
117
118
119
120
121
122
123
124
          setMapToTaxonomy(0, ocs);
        }
        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.
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.