1*cdf0e10cSrcweir/************************************************************************* 2*cdf0e10cSrcweir * 3*cdf0e10cSrcweir * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER. 4*cdf0e10cSrcweir * 5*cdf0e10cSrcweir * Copyright 2000, 2010 Oracle and/or its affiliates. 6*cdf0e10cSrcweir * 7*cdf0e10cSrcweir * OpenOffice.org - a multi-platform office productivity suite 8*cdf0e10cSrcweir * 9*cdf0e10cSrcweir * This file is part of OpenOffice.org. 10*cdf0e10cSrcweir * 11*cdf0e10cSrcweir * OpenOffice.org is free software: you can redistribute it and/or modify 12*cdf0e10cSrcweir * it under the terms of the GNU Lesser General Public License version 3 13*cdf0e10cSrcweir * only, as published by the Free Software Foundation. 14*cdf0e10cSrcweir * 15*cdf0e10cSrcweir * OpenOffice.org is distributed in the hope that it will be useful, 16*cdf0e10cSrcweir * but WITHOUT ANY WARRANTY; without even the implied warranty of 17*cdf0e10cSrcweir * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the 18*cdf0e10cSrcweir * GNU Lesser General Public License version 3 for more details 19*cdf0e10cSrcweir * (a copy is included in the LICENSE file that accompanied this code). 20*cdf0e10cSrcweir * 21*cdf0e10cSrcweir * You should have received a copy of the GNU Lesser General Public License 22*cdf0e10cSrcweir * version 3 along with OpenOffice.org. If not, see 23*cdf0e10cSrcweir * <http://www.openoffice.org/license.html> 24*cdf0e10cSrcweir * for a copy of the LGPLv3 License. 25*cdf0e10cSrcweir * 26*cdf0e10cSrcweir ************************************************************************/ 27*cdf0e10cSrcweir#ifndef __com_sun_star_sdbc_XParameters_idl__ 28*cdf0e10cSrcweir#define __com_sun_star_sdbc_XParameters_idl__ 29*cdf0e10cSrcweir 30*cdf0e10cSrcweir#ifndef __com_sun_star_uno_XInterface_idl__ 31*cdf0e10cSrcweir#include <com/sun/star/uno/XInterface.idl> 32*cdf0e10cSrcweir#endif 33*cdf0e10cSrcweir 34*cdf0e10cSrcweir#ifndef __com_sun_star_util_Date_idl__ 35*cdf0e10cSrcweir#include <com/sun/star/util/Date.idl> 36*cdf0e10cSrcweir#endif 37*cdf0e10cSrcweir 38*cdf0e10cSrcweir#ifndef __com_sun_star_util_DateTime_idl__ 39*cdf0e10cSrcweir#include <com/sun/star/util/DateTime.idl> 40*cdf0e10cSrcweir#endif 41*cdf0e10cSrcweir 42*cdf0e10cSrcweir#ifndef __com_sun_star_util_Time_idl__ 43*cdf0e10cSrcweir#include <com/sun/star/util/Time.idl> 44*cdf0e10cSrcweir#endif 45*cdf0e10cSrcweir 46*cdf0e10cSrcweir module com { module sun { module star { module io { 47*cdf0e10cSrcweir published interface XInputStream; 48*cdf0e10cSrcweir};};};}; 49*cdf0e10cSrcweir 50*cdf0e10cSrcweir#ifndef __com_sun_star_sdbc_SQLException_idl__ 51*cdf0e10cSrcweir#include <com/sun/star/sdbc/SQLException.idl> 52*cdf0e10cSrcweir#endif 53*cdf0e10cSrcweir 54*cdf0e10cSrcweir module com { module sun { module star { module sdbc { 55*cdf0e10cSrcweir 56*cdf0e10cSrcweir published interface XRef; 57*cdf0e10cSrcweir published interface XArray; 58*cdf0e10cSrcweir published interface XBlob; 59*cdf0e10cSrcweir published interface XClob; 60*cdf0e10cSrcweir 61*cdf0e10cSrcweir 62*cdf0e10cSrcweir/** is used for parameter setting, commonly implemented in conjunction with 63*cdf0e10cSrcweir PreparedStatements. 64*cdf0e10cSrcweir 65*cdf0e10cSrcweir 66*cdf0e10cSrcweir <p> 67*cdf0e10cSrcweir <b>Note:</b> The setXXX methods for setting IN parameter values 68*cdf0e10cSrcweir must specify types that are compatible with the defined SQL type of 69*cdf0e10cSrcweir the input parameter. For instance, if the IN parameter has SQL type 70*cdf0e10cSrcweir Integer, then the method 71*cdf0e10cSrcweir <member scope="com::sun::star::sdbc">XParameters::setInt()</member> 72*cdf0e10cSrcweir should be used. 73*cdf0e10cSrcweir 74*cdf0e10cSrcweir </p> 75*cdf0e10cSrcweir <p> 76*cdf0e10cSrcweir If arbitrary parameter type conversions are required, the method 77*cdf0e10cSrcweir <member scope="com::sun::star::sdbc">XParameters::setObject()</member> 78*cdf0e10cSrcweir should be used with a target SQL type. 79*cdf0e10cSrcweir <br/> 80*cdf0e10cSrcweir <br/> 81*cdf0e10cSrcweir Example of setting a parameter; 82*cdf0e10cSrcweir <code>con</code> 83*cdf0e10cSrcweir is an active connection. 84*cdf0e10cSrcweir </p> 85*cdf0e10cSrcweir 86*cdf0e10cSrcweir @example <listing>pstmt = con.prepareStatement("UPDATE EMPLOYEES SET SALARY = ? WHERE ID = ?") 87*cdf0e10cSrcweir pstmt.setDouble(1, 153833.00) 88*cdf0e10cSrcweir pstmt.setLong(2, 110592) 89*cdf0e10cSrcweir </listing>@see com::sun::star::sdbc::XPreparedStatement 90*cdf0e10cSrcweir */ 91*cdf0e10cSrcweirpublished interface XParameters: com::sun::star::uno::XInterface 92*cdf0e10cSrcweir{ 93*cdf0e10cSrcweir 94*cdf0e10cSrcweir /** sets the designated parameter to SQL NULL. 95*cdf0e10cSrcweir */ 96*cdf0e10cSrcweir void setNull([in]long parameterIndex, 97*cdf0e10cSrcweir [in]long sqlType) raises (SQLException); 98*cdf0e10cSrcweir //------------------------------------------------------------------------- 99*cdf0e10cSrcweir 100*cdf0e10cSrcweir /** sets the designated parameter to SQL NULL. This version of setNull should 101*cdf0e10cSrcweir be used for user-named types and REF type parameters. Examples 102*cdf0e10cSrcweir of user-named types include: STRUCT, DISTINCT, OBJECT, and 103*cdf0e10cSrcweir named array types. 104*cdf0e10cSrcweir 105*cdf0e10cSrcweir 106*cdf0e10cSrcweir <p> 107*cdf0e10cSrcweir <b>Note:</b> To be portable, applications must give the 108*cdf0e10cSrcweir SQL type code and the fully-qualified SQL type name when specifying 109*cdf0e10cSrcweir a NULL user-defined or REF parameter. In the case of a user-named type 110*cdf0e10cSrcweir the name is the type name of the parameter itself. For a REF 111*cdf0e10cSrcweir parameter the name is the type name of the referenced type. If 112*cdf0e10cSrcweir a SDBC driver does not need the type code or type name information, 113*cdf0e10cSrcweir it may ignore it. 114*cdf0e10cSrcweir <br/> 115*cdf0e10cSrcweir Although it is intended for user-named and Ref parameters, 116*cdf0e10cSrcweir this method may be used to set a null parameter of any JDBC type. 117*cdf0e10cSrcweir If the parameter does not have a user-named or REF type, the given 118*cdf0e10cSrcweir typeName is ignored. 119*cdf0e10cSrcweir </p> 120*cdf0e10cSrcweir @param parameterIndex 121*cdf0e10cSrcweir the first parameter is 1, the second is 2, ... 122*cdf0e10cSrcweir @param sqlType 123*cdf0e10cSrcweir the type of the column to set to <NULL/> 124*cdf0e10cSrcweir @param typeName 125*cdf0e10cSrcweir the name of the type 126*cdf0e10cSrcweir @throws SQLException 127*cdf0e10cSrcweir if a database access error occurs. 128*cdf0e10cSrcweir */ 129*cdf0e10cSrcweir void setObjectNull([in]long parameterIndex, 130*cdf0e10cSrcweir [in]long sqlType, 131*cdf0e10cSrcweir [in]string typeName) raises (SQLException); 132*cdf0e10cSrcweir //------------------------------------------------------------------------- 133*cdf0e10cSrcweir 134*cdf0e10cSrcweir /** sets the designated parameter to a boolean value. The driver converts this 135*cdf0e10cSrcweir to a SQL BIT value when it sends it to the database. 136*cdf0e10cSrcweir @param parameterIndex 137*cdf0e10cSrcweir the first parameter is 1, the second is 2, ... 138*cdf0e10cSrcweir @param x 139*cdf0e10cSrcweir the parameter value 140*cdf0e10cSrcweir @throws SQLException 141*cdf0e10cSrcweir if a database access error occurs. 142*cdf0e10cSrcweir */ 143*cdf0e10cSrcweir void setBoolean([in]long parameterIndex, [in]boolean x) 144*cdf0e10cSrcweir raises (SQLException); 145*cdf0e10cSrcweir //------------------------------------------------------------------------- 146*cdf0e10cSrcweir 147*cdf0e10cSrcweir /** sets the designated parameter to a byte value. The driver converts this 148*cdf0e10cSrcweir to a SQL TINYINT value when it sends it to the database. 149*cdf0e10cSrcweir @param parameterIndex 150*cdf0e10cSrcweir the first parameter is 1, the second is 2, ... 151*cdf0e10cSrcweir @param x 152*cdf0e10cSrcweir the parameter value 153*cdf0e10cSrcweir @throws SQLException 154*cdf0e10cSrcweir if a database access error occurs. 155*cdf0e10cSrcweir */ 156*cdf0e10cSrcweir void setByte([in]long parameterIndex, [in]byte x) raises (SQLException); 157*cdf0e10cSrcweir //------------------------------------------------------------------------- 158*cdf0e10cSrcweir 159*cdf0e10cSrcweir /** sets the designated parameter to a short value. The driver converts this 160*cdf0e10cSrcweir to a SQL SMALLINT value when it sends it to the database. 161*cdf0e10cSrcweir @param parameterIndex 162*cdf0e10cSrcweir the first parameter is 1, the second is 2, ... 163*cdf0e10cSrcweir @param x 164*cdf0e10cSrcweir the parameter value 165*cdf0e10cSrcweir @throws SQLException 166*cdf0e10cSrcweir if a database access error occurs. 167*cdf0e10cSrcweir */ 168*cdf0e10cSrcweir void setShort([in]long parameterIndex, [in]short x) raises (SQLException); 169*cdf0e10cSrcweir //------------------------------------------------------------------------- 170*cdf0e10cSrcweir 171*cdf0e10cSrcweir /** sets the designated parameter to a long value. The driver converts this 172*cdf0e10cSrcweir to a SQL INTEGER value when it sends it to the database. 173*cdf0e10cSrcweir @param parameterIndex 174*cdf0e10cSrcweir the first parameter is 1, the second is 2, ... 175*cdf0e10cSrcweir @param x 176*cdf0e10cSrcweir the parameter value 177*cdf0e10cSrcweir @throws SQLException 178*cdf0e10cSrcweir if a database access error occurs. 179*cdf0e10cSrcweir */ 180*cdf0e10cSrcweir void setInt([in]long parameterIndex, [in]long x) raises (SQLException); 181*cdf0e10cSrcweir //------------------------------------------------------------------------- 182*cdf0e10cSrcweir 183*cdf0e10cSrcweir /** sets the designated parameter to a hyper value. The driver converts this 184*cdf0e10cSrcweir to a SQL BIGINT value when it sends it to the database. 185*cdf0e10cSrcweir @param parameterIndex 186*cdf0e10cSrcweir the first parameter is 1, the second is 2, ... 187*cdf0e10cSrcweir @param x 188*cdf0e10cSrcweir the parameter value 189*cdf0e10cSrcweir @throws SQLException 190*cdf0e10cSrcweir if a database access error occurs. 191*cdf0e10cSrcweir */ 192*cdf0e10cSrcweir void setLong([in]long parameterIndex, [in]hyper x) raises (SQLException); 193*cdf0e10cSrcweir //------------------------------------------------------------------------- 194*cdf0e10cSrcweir 195*cdf0e10cSrcweir /** sets the designated parameter to a float value. The driver converts this 196*cdf0e10cSrcweir to a SQL FLOAT value when it sends it to the database. 197*cdf0e10cSrcweir @param parameterIndex 198*cdf0e10cSrcweir the first parameter is 1, the second is 2, ... 199*cdf0e10cSrcweir @param x 200*cdf0e10cSrcweir the parameter value 201*cdf0e10cSrcweir @throws SQLException 202*cdf0e10cSrcweir if a database access error occurs. 203*cdf0e10cSrcweir */ 204*cdf0e10cSrcweir void setFloat([in]long parameterIndex, [in]float x) raises (SQLException); 205*cdf0e10cSrcweir //------------------------------------------------------------------------- 206*cdf0e10cSrcweir 207*cdf0e10cSrcweir /** sets the designated parameter to a double value. The driver converts this 208*cdf0e10cSrcweir to a SQL DOUBLE value when it sends it to the database. 209*cdf0e10cSrcweir @param parameterIndex 210*cdf0e10cSrcweir the first parameter is 1, the second is 2, ... 211*cdf0e10cSrcweir @param x 212*cdf0e10cSrcweir the parameter value 213*cdf0e10cSrcweir @throws SQLException 214*cdf0e10cSrcweir if a database access error occurs. 215*cdf0e10cSrcweir */ 216*cdf0e10cSrcweir void setDouble([in]long parameterIndex, [in]double x) raises (SQLException); 217*cdf0e10cSrcweir //------------------------------------------------------------------------- 218*cdf0e10cSrcweir 219*cdf0e10cSrcweir /** sets the designated parameter to a string value. The driver converts this 220*cdf0e10cSrcweir to a SQL VARCHAR or LONGVARCHAR value (depending on the argument's 221*cdf0e10cSrcweir size relative to the driver's limits on VARCHARs) when it sends 222*cdf0e10cSrcweir it to the database. 223*cdf0e10cSrcweir @param parameterIndex 224*cdf0e10cSrcweir the first parameter is 1, the second is 2, ... 225*cdf0e10cSrcweir @param x 226*cdf0e10cSrcweir the parameter value 227*cdf0e10cSrcweir @throws SQLException 228*cdf0e10cSrcweir if a database access error occurs. 229*cdf0e10cSrcweir */ 230*cdf0e10cSrcweir void setString([in]long parameterIndex, [in]string x) raises (SQLException); 231*cdf0e10cSrcweir //------------------------------------------------------------------------- 232*cdf0e10cSrcweir 233*cdf0e10cSrcweir /** sets the designated parameter to a sequence of bytes. The driver converts 234*cdf0e10cSrcweir this to a SQL VARBINARY or LONGVARBINARY (depending on the 235*cdf0e10cSrcweir argument's size relative to the driver's limits on VARBINARYs) 236*cdf0e10cSrcweir when it sends it to the database. 237*cdf0e10cSrcweir @param parameterIndex 238*cdf0e10cSrcweir the first parameter is 1, the second is 2, ... 239*cdf0e10cSrcweir @param x 240*cdf0e10cSrcweir the parameter value 241*cdf0e10cSrcweir @throws SQLException 242*cdf0e10cSrcweir if a database access error occurs. 243*cdf0e10cSrcweir */ 244*cdf0e10cSrcweir void setBytes([in]long parameterIndex, [in]sequence<byte> x) 245*cdf0e10cSrcweir raises (SQLException); 246*cdf0e10cSrcweir //------------------------------------------------------------------------- 247*cdf0e10cSrcweir 248*cdf0e10cSrcweir /** sets the designated parameter to a date value. The driver converts this 249*cdf0e10cSrcweir to a SQL DATE value when it sends it to the database. 250*cdf0e10cSrcweir @param parameterIndex 251*cdf0e10cSrcweir the first parameter is 1, the second is 2, ... 252*cdf0e10cSrcweir @param x 253*cdf0e10cSrcweir the parameter value 254*cdf0e10cSrcweir @throws SQLException 255*cdf0e10cSrcweir if a database access error occurs. 256*cdf0e10cSrcweir */ 257*cdf0e10cSrcweir void setDate([in]long parameterIndex, [in]com::sun::star::util::Date x) 258*cdf0e10cSrcweir raises (SQLException); 259*cdf0e10cSrcweir //------------------------------------------------------------------------- 260*cdf0e10cSrcweir 261*cdf0e10cSrcweir /** sets the designated parameter to a time value. The driver converts this 262*cdf0e10cSrcweir to a SQL TIME value when it sends it to the database. 263*cdf0e10cSrcweir @param parameterIndex 264*cdf0e10cSrcweir the first parameter is 1, the second is 2, ... 265*cdf0e10cSrcweir @param x 266*cdf0e10cSrcweir the parameter value 267*cdf0e10cSrcweir @throws SQLException 268*cdf0e10cSrcweir if a database access error occurs. 269*cdf0e10cSrcweir */ 270*cdf0e10cSrcweir void setTime([in]long parameterIndex, [in]com::sun::star::util::Time x) 271*cdf0e10cSrcweir raises (SQLException); 272*cdf0e10cSrcweir //------------------------------------------------------------------------- 273*cdf0e10cSrcweir 274*cdf0e10cSrcweir /** sets the designated parameter to a datetime value. The driver 275*cdf0e10cSrcweir converts this to a SQL TIMESTAMP value when it sends it to the 276*cdf0e10cSrcweir database. 277*cdf0e10cSrcweir @param parameterIndex 278*cdf0e10cSrcweir the first parameter is 1, the second is 2, ... 279*cdf0e10cSrcweir @param x 280*cdf0e10cSrcweir the parameter value 281*cdf0e10cSrcweir @throws SQLException 282*cdf0e10cSrcweir if a database access error occurs. 283*cdf0e10cSrcweir */ 284*cdf0e10cSrcweir void setTimestamp([in]long parameterIndex, 285*cdf0e10cSrcweir [in]com::sun::star::util::DateTime x) raises (SQLException); 286*cdf0e10cSrcweir //------------------------------------------------------------------------- 287*cdf0e10cSrcweir 288*cdf0e10cSrcweir /** sets the designated parameter to the given input stream, which will have 289*cdf0e10cSrcweir the specified number of bytes. 290*cdf0e10cSrcweir When a very large binary value is input to a LONGVARBINARY or LONGVARCHAR 291*cdf0e10cSrcweir parameter, it may be more practical to send it via an 292*cdf0e10cSrcweir <type scope="com::sun::star::io">XInputStream</type> 293*cdf0e10cSrcweir . SDBC will read the data from the stream as needed, until it reaches end-of-file. 294*cdf0e10cSrcweir @param parameterIndex 295*cdf0e10cSrcweir the first parameter is 1, the second is 2, ... 296*cdf0e10cSrcweir @param x 297*cdf0e10cSrcweir the parameter value 298*cdf0e10cSrcweir @param length 299*cdf0e10cSrcweir the number of bytes in the stream 300*cdf0e10cSrcweir @throws SQLException 301*cdf0e10cSrcweir if a database access error occurs. 302*cdf0e10cSrcweir */ 303*cdf0e10cSrcweir void setBinaryStream([in]long parameterIndex, 304*cdf0e10cSrcweir [in]com::sun::star::io::XInputStream x, 305*cdf0e10cSrcweir [in]long length) raises (SQLException); 306*cdf0e10cSrcweir //------------------------------------------------------------------------- 307*cdf0e10cSrcweir 308*cdf0e10cSrcweir /** sets the designated parameter to the given input stream, which will have 309*cdf0e10cSrcweir the specified number of bytes. 310*cdf0e10cSrcweir When a very large binary value is input to a LONGVARCHAR 311*cdf0e10cSrcweir parameter, it may be more practical to send it via a 312*cdf0e10cSrcweir <type scope="com::sun::star::io">XInputStream</type> 313*cdf0e10cSrcweir . SDBC will read the data from the stream as needed, until it reaches end-of-file. 314*cdf0e10cSrcweir @param parameterIndex 315*cdf0e10cSrcweir the first parameter is 1, the second is 2, ... 316*cdf0e10cSrcweir @param x 317*cdf0e10cSrcweir the parameter value 318*cdf0e10cSrcweir @param length 319*cdf0e10cSrcweir the number of characters in the stream 320*cdf0e10cSrcweir @throws SQLException 321*cdf0e10cSrcweir if a database access error occurs. 322*cdf0e10cSrcweir */ 323*cdf0e10cSrcweir void setCharacterStream([in]long parameterIndex, 324*cdf0e10cSrcweir [in]com::sun::star::io::XInputStream x, 325*cdf0e10cSrcweir [in]long length) raises (SQLException); 326*cdf0e10cSrcweir //------------------------------------------------------------------------- 327*cdf0e10cSrcweir 328*cdf0e10cSrcweir /** sets the value of a parameter using an any. 329*cdf0e10cSrcweir 330*cdf0e10cSrcweir 331*cdf0e10cSrcweir <p>The given object will be converted to the targetSqlType 332*cdf0e10cSrcweir before being sent to the database. 333*cdf0e10cSrcweir If the object has a custom mapping (is of a class implementing SQLData), 334*cdf0e10cSrcweir the SDBC driver should call its method <code>writeSQL</code> to write it 335*cdf0e10cSrcweir to the SQL data stream. 336*cdf0e10cSrcweir If, on the other hand, the object is of a service implementing Ref, Blob, 337*cdf0e10cSrcweir Clob, Struct, or Array, the driver should pass it to the database as a 338*cdf0e10cSrcweir value of the corresponding SQL type. 339*cdf0e10cSrcweir </p> 340*cdf0e10cSrcweir <p>Note that this method may be used to pass database-specific 341*cdf0e10cSrcweir abstract data types. 342*cdf0e10cSrcweir </p> 343*cdf0e10cSrcweir @param parameterIndex 344*cdf0e10cSrcweir the first parameter is 1, the second is 2, ... 345*cdf0e10cSrcweir @param x 346*cdf0e10cSrcweir the parameter value 347*cdf0e10cSrcweir @throws SQLException 348*cdf0e10cSrcweir if a database access error occurs. 349*cdf0e10cSrcweir */ 350*cdf0e10cSrcweir void setObject([in]long parameterIndex, [in]any x) 351*cdf0e10cSrcweir raises (SQLException); 352*cdf0e10cSrcweir //------------------------------------------------------------------------- 353*cdf0e10cSrcweir 354*cdf0e10cSrcweir /** set a value from the Datatype ANY for a parameter. 355*cdf0e10cSrcweir 356*cdf0e10cSrcweir 357*cdf0e10cSrcweir 358*cdf0e10cSrcweir <p>The given object will be converted to the targetSqlType 359*cdf0e10cSrcweir before being sent to the database. 360*cdf0e10cSrcweir If the object has a custom mapping (is of a class implementing SQLData), 361*cdf0e10cSrcweir the SDBC driver should call its method <code>writeSQL</code> to write it 362*cdf0e10cSrcweir to the SQL data stream. 363*cdf0e10cSrcweir If, on the other hand, the object is of a service implementing Ref, Blob, 364*cdf0e10cSrcweir Clob, Struct, or Array, the driver should pass it to the database as a 365*cdf0e10cSrcweir value of the corresponding SQL type. 366*cdf0e10cSrcweir </p> 367*cdf0e10cSrcweir <p>Note that this method may be used to pass database-specific 368*cdf0e10cSrcweir abstract data types. 369*cdf0e10cSrcweir </p> 370*cdf0e10cSrcweir @param parameterIndex 371*cdf0e10cSrcweir the first parameter is 1, the second is 2, ... 372*cdf0e10cSrcweir @param x 373*cdf0e10cSrcweir the parameter value 374*cdf0e10cSrcweir @param targetSqlType 375*cdf0e10cSrcweir the SQL type (as defined in 376*cdf0e10cSrcweir <type scope="com::sun::star::sdbc">DataType</type> 377*cdf0e10cSrcweir ) to be sent to the database. The scale argument may further qualify this type. 378*cdf0e10cSrcweir @param scale 379*cdf0e10cSrcweir for 380*cdf0e10cSrcweir <member scope="com::sun::star::sdbc">DataType::DECIMAL</member> 381*cdf0e10cSrcweir or 382*cdf0e10cSrcweir <member scope="com::sun::star::sdbc">DataType::NUMERIC</member> 383*cdf0e10cSrcweir types, this is the number of digits after the decimal point. For all other types, this value will be ignored. 384*cdf0e10cSrcweir @throws SQLException 385*cdf0e10cSrcweir if a database access error occurs. 386*cdf0e10cSrcweir */ 387*cdf0e10cSrcweir void setObjectWithInfo([in]long parameterIndex, 388*cdf0e10cSrcweir [in]any x, [in]long targetSqlType, [in]long scale) 389*cdf0e10cSrcweir raises (SQLException); 390*cdf0e10cSrcweir //------------------------------------------------------------------------- 391*cdf0e10cSrcweir 392*cdf0e10cSrcweir /** sets a REF(&lt;structured-type&gt;) parameter. 393*cdf0e10cSrcweir @param parameterIndex 394*cdf0e10cSrcweir the first parameter is 1, the second is 2, ... 395*cdf0e10cSrcweir @param x 396*cdf0e10cSrcweir the parameter value 397*cdf0e10cSrcweir @throws SQLException 398*cdf0e10cSrcweir if a database access error occurs. 399*cdf0e10cSrcweir */ 400*cdf0e10cSrcweir void setRef ([in]long parameterIndex, [in]XRef x) raises (SQLException); 401*cdf0e10cSrcweir //------------------------------------------------------------------------- 402*cdf0e10cSrcweir 403*cdf0e10cSrcweir /** sets a BLOB parameter. 404*cdf0e10cSrcweir @param parameterIndex 405*cdf0e10cSrcweir the first parameter is 1, the second is 2, ... 406*cdf0e10cSrcweir @param x 407*cdf0e10cSrcweir the parameter value 408*cdf0e10cSrcweir @throws SQLException 409*cdf0e10cSrcweir if a database access error occurs. 410*cdf0e10cSrcweir */ 411*cdf0e10cSrcweir void setBlob ([in]long parameterIndex, [in]XBlob x) raises (SQLException); 412*cdf0e10cSrcweir //------------------------------------------------------------------------- 413*cdf0e10cSrcweir 414*cdf0e10cSrcweir /** sets a CLOB parameter. 415*cdf0e10cSrcweir @param parameterIndex 416*cdf0e10cSrcweir the first parameter is 1, the second is 2, ... 417*cdf0e10cSrcweir @param x 418*cdf0e10cSrcweir the parameter value 419*cdf0e10cSrcweir @throws SQLException 420*cdf0e10cSrcweir if a database access error occurs. 421*cdf0e10cSrcweir */ 422*cdf0e10cSrcweir void setClob ([in]long parameterIndex, [in]XClob x) raises (SQLException); 423*cdf0e10cSrcweir //------------------------------------------------------------------------- 424*cdf0e10cSrcweir 425*cdf0e10cSrcweir /** sets an Array parameter. 426*cdf0e10cSrcweir @param parameterIndex 427*cdf0e10cSrcweir the first parameter is 1, the second is 2, ... 428*cdf0e10cSrcweir @param x 429*cdf0e10cSrcweir the parameter value 430*cdf0e10cSrcweir @throws SQLException 431*cdf0e10cSrcweir if a database access error occurs. 432*cdf0e10cSrcweir */ 433*cdf0e10cSrcweir void setArray ([in]long parameterIndex, [in]XArray x) raises (SQLException); 434*cdf0e10cSrcweir 435*cdf0e10cSrcweir //------------------------------------------------------------------------- 436*cdf0e10cSrcweir 437*cdf0e10cSrcweir /** clears the current parameter values immediately. 438*cdf0e10cSrcweir 439*cdf0e10cSrcweir 440*cdf0e10cSrcweir <p>In general, parameter values remain in force for repeated use of a 441*cdf0e10cSrcweir Statement. Setting a parameter value automatically clears its 442*cdf0e10cSrcweir previous value. However, in some cases it is useful to immediately 443*cdf0e10cSrcweir release the resources used by the current parameter values; this can 444*cdf0e10cSrcweir be done by calling clearParameters. 445*cdf0e10cSrcweir </p> 446*cdf0e10cSrcweir @throws SQLException 447*cdf0e10cSrcweir if a database access error occurs. 448*cdf0e10cSrcweir */ 449*cdf0e10cSrcweir void clearParameters() raises (SQLException); 450*cdf0e10cSrcweir}; 451*cdf0e10cSrcweir 452*cdf0e10cSrcweir//============================================================================= 453*cdf0e10cSrcweir 454*cdf0e10cSrcweir}; }; }; }; 455*cdf0e10cSrcweir 456*cdf0e10cSrcweir/*=========================================================================== 457*cdf0e10cSrcweir===========================================================================*/ 458*cdf0e10cSrcweir#endif 459