Package java.sql

Examples of java.sql.CallableStatement.execute()

1495
1496
1497
1498
1499
1500
1501
1502
1503
1504
1505
    if (DBBind.exists(oConn, DB.k_sales_men, "U")) {
       if (DebugFile.trace) DebugFile.writeln("Connection.prepareCall({ call k_sp_del_sales_man ('" + sUserGUID + "') })");

       oCall = oConn.prepareCall("{call k_sp_del_sales_man ('" + sUserGUID + "')}");
       bRetVal = oCall.execute();
       oCall.close();
     }

    if (DBBind.exists(oConn, DB.k_products, "U")) {
      oProds = new DBSubset(DB.k_products, DB.gu_product, DB.gu_owner + "='" + sUserGUID + "'", 100);
View Full Code Here
1550
1551
1552
1553
1554
1555
1556
1557
1558
1559
1560
    } // fi (exists(oConn, DB.k_to_do))

    if (DebugFile.trace) DebugFile.writeln("Connection.prepareCall({ call k_sp_del_user ('" + sUserGUID + "') })");

    oCall = oConn.prepareCall("{call k_sp_del_user ('" + sUserGUID + "')}");
    bRetVal = oCall.execute();
    oCall.close();

    if (DebugFile.trace) {
      DebugFile.decIdent();
      DebugFile.writeln("End ACLUser.delete() : " + String.valueOf(bRetVal));
View Full Code Here
104
105
106
107
108
109
110
111
112
113
114
      oCall = oConn.prepareCall("{ call k_get_account_tp (?,?) }");

      oCall.setString(1, sUserId);
      oCall.registerOutParameter(2, Types.CHAR);

      oCall.execute();

      if (JDCConnection.DBMS_ORACLE==oConn.getDataBaseProduct())
        sTp = oCall.getString(2);
      else
        sTp = oCall.getString(2);
View Full Code Here
145
146
147
148
149
150
151
152
153
154
155
    }
    else {
      oCall = oConn.prepareCall("{ call k_check_account (?,?) }");
      oCall.setString(1, sAccId);
      oCall.registerOutParameter(2, Types.SMALLINT);
      oCall.execute();
      iActive = oCall.getShort(2);
      oCall.close();
    }

    return ((short)0!=iActive);
View Full Code Here
181
182
183
184
185
186
187
188
189
190
191
    }
    else {
      oCall = oConn.prepareCall("{ call k_get_account_days_left (?,?) }");
      oCall.setString(1, sAccId);
      oCall.registerOutParameter(2, Types.INTEGER);
      oCall.execute();
      iDaysLeft = oCall.getInt(2);
      oCall.close();
    }

    return iDaysLeft;
View Full Code Here
216
217
218
219
220
221
222
223
224
225
226
    }
    else {
      oCall = oConn.prepareCall("{ call k_get_account_trial (?,?) }");
      oCall.setString(1, sAccId);
      oCall.registerOutParameter(2, Types.SMALLINT);
      oCall.execute();
      iTrial = oCall.getShort(2);
      oCall.close();
    }

    return ((short)0!=iTrial);
View Full Code Here
638
639
640
641
642
643
644
645
646
647
648
      if (DebugFile.trace)
        DebugFile.writeln ("Conenction.prepareCall({call k_sp_del_company ('" + sCompanyGUID + "')}");

      CallableStatement oCall = oConn.prepareCall("{call k_sp_del_company ('" + sCompanyGUID + "')}");
      bRetVal = oCall.execute();
      oCall.close();
    }

    if (DebugFile.trace) {
      DebugFile.decIdent();
View Full Code Here
234
235
236
237
238
239
240
241
242
243
244
      if (sTxPersonal!=null)
        oCall.setString(7, sTxPersonal);
      else
        oCall.setNull(7, Types.VARCHAR);
      if (DebugFile.trace) DebugFile.writeln("CallableStatement.execute()");
      oCall.execute();
      oCall.close();
    }
    else {
      if (DebugFile.trace) DebugFile.writeln("{call k_sp_write_inet_addr (?,?,?,?,?,?,?)}");
      CallableStatement oCall = oConn.prepareCall("{call k_sp_write_inet_addr (?,?,?,?,?,?,?)}");
View Full Code Here
251
252
253
254
255
256
257
258
259
260
261
      if (sTxPersonal!=null)
        oCall.setString(7, sTxPersonal);
      else
        oCall.setNull(7, Types.VARCHAR);
      if (DebugFile.trace) DebugFile.writeln("CallableStatement.execute()");
      oCall.execute();
      oCall.close();
    }
    if (DebugFile.trace) {
      DebugFile.decIdent();
      DebugFile.writeln("End DBInetAddr.write()");
View Full Code Here
114
115
116
117
118
119
120
121
122
123
124
      oStmt.executeQuery();
      oStmt.close();
    } else {
      CallableStatement oCall = oConn.prepareCall("{ call k_sp_del_supplier(?) }");
      oCall.setString(1, sGuSupplier);
      oCall.execute();
      oCall.close();
    }
    return true;
  } // delete
 
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.