Package java.sql

Examples of java.sql.CallableStatement.execute()

1105
1106
1107
1108
1109
1110
1111
1112
1113
1114
1115
    else {
      if (DebugFile.trace)
        DebugFile.writeln("Connection.prepareCall({ call k_sp_del_contact ('" + sContactGUID + "') }");

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

    if (DebugFile.trace) {
      DebugFile.decIdent();
View Full Code Here
554
555
556
557
558
559
560
561
562
563
564
      else {
        if (DebugFile.trace) DebugFile.writeln("Connection.prepareCall({ call k_sp_del_sales_man (?) })");
         oCall = oConn.prepareCall("{call k_sp_del_sales_man (?)}");
         for (int c=0;c<iItems; c++) {
           oCall.setString(1, oItems.getString(0,c));
           oCall.execute();
         } // next
         oCall.close();
      }
    } // fi (DBMS_POSTGRESQL)
View Full Code Here
1031
1032
1033
1034
1035
1036
1037
1038
1039
1040
1041
      }
      else {
        oCall = oConn.prepareCall("{call k_sp_del_course (?)}");
       for (int c=0;c<iItems; c++) {
         oCall.setString(1, oItems.getString(0,c));
         oCall.execute();
       }
       oCall.close();
      } // fi (DBMS_POSTGRESQL)
    } // fi (exists(DB.k_courses))
View Full Code Here
1379
1380
1381
1382
1383
1384
1385
1386
1387
1388
1389
        oCall = oConn.prepareCall("{ call k_is_workarea_admin (?,?,?)}");

        oCall.setString(1, guWorkArea);
        oCall.setString(2, sUserId);
        oCall.registerOutParameter(3, Types.DECIMAL);
        oCall.execute();
        iIsAdmin = oCall.getBigDecimal(3).intValue();
        oCall.close();
        break;

      case JDCConnection.DBMS_MSSQL:
View Full Code Here
1395
1396
1397
1398
1399
1400
1401
1402
1403
1404
1405
        oCall = oConn.prepareCall("{ call k_is_workarea_admin (?,?,?)}");

        oCall.setString(1, guWorkArea);
        oCall.setString(2, sUserId);
        oCall.registerOutParameter(3, Types.INTEGER);
        oCall.execute();
        iIsAdmin = oCall.getInt(3);
        oCall.close();
        break;

      default:
View Full Code Here
1459
1460
1461
1462
1463
1464
1465
1466
1467
1468
1469
        oCall = oConn.prepareCall("{ call k_is_workarea_poweruser (?,?,?)}");

        oCall.setString(1, guWorkArea);
        oCall.setString(2, sUserId);
        oCall.registerOutParameter(3, Types.DECIMAL);
        oCall.execute();
        iIsPowerUser = oCall.getBigDecimal(3).intValue();
        oCall.close();
        break;

      case JDCConnection.DBMS_MSSQL:
View Full Code Here
1475
1476
1477
1478
1479
1480
1481
1482
1483
1484
1485
        oCall = oConn.prepareCall("{ call k_is_workarea_poweruser (?,?,?)}");

        oCall.setString(1, guWorkArea);
        oCall.setString(2, sUserId);
        oCall.registerOutParameter(3, Types.INTEGER);
        oCall.execute();
        iIsPowerUser = oCall.getInt(3);
        oCall.close();
        break;

      default:
View Full Code Here
946
947
948
949
950
951
952
953
954
955
956
        if (DebugFile.trace) DebugFile.writeln("Connection.prepareCall({call k_sp_currval ('" + sSequenceName + "',?)})" );

        oCall = oConn.prepareCall("{call k_sp_currval (?,?)}");
        oCall.setString(1, sSequenceName);
        oCall.registerOutParameter(2, java.sql.Types.INTEGER);
        oCall.execute();
        iCurrVal = oCall.getInt(2);
        oCall.close();
        oCall = null;
        break;
View Full Code Here
1057
1058
1059
1060
1061
1062
1063
1064
1065
1066
1067
        if (DebugFile.trace) DebugFile.writeln("Connection.prepareCall({call k_sp_nextval ('" + sSequenceName + "',?)})" );

        oCall = oConn.prepareCall("{call k_sp_nextval (?,?)}");
        oCall.setString(1, sSequenceName);
        oCall.registerOutParameter(2, java.sql.Types.INTEGER);
        oCall.execute();
        iNextVal = oCall.getInt(2);
        oCall.close();
        oCall = null;
        break;
View Full Code Here
155
156
157
158
159
160
161
162
163
164
165
    }
    else {
      if (DebugFile.trace) DebugFile.writeln("Connection.prepareCall({ call k_sp_del_oportunity('" + sOportunityGUID + "')})");

      oCall = oConn.prepareCall("{ call k_sp_del_oportunity ('" + sOportunityGUID + "')}");
      bRetVal = oCall.execute();
      oCall.close();
    }
    if (DebugFile.trace) {
      DebugFile.decIdent();
      DebugFile.writeln("End Oportunity.delete() : " + String.valueOf(bRetVal));
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.