📄 oracle.jdbc.driver.oraclecallablestatement.html
字号:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"><!--NewPage--><html><head><!-- Generated by javadoc on Thu Dec 02 03:30:11 PST 1999 --><title> Class oracle.jdbc.driver.OracleCallableStatement</title></head><body><a name="_top_"></a><pre><a href="packages.html">All Packages</a> <a href="tree.html">Class Hierarchy</a> <a href="Package-oracle.jdbc.driver.html">This Package</a> <a href="Package-oracle.jdbc.driver.html">Previous</a> <a href="oracle.jdbc.driver.OracleConnection.html#_top_">Next</a> <a href="AllNames.html">Index</a></pre><hr><h1> Class oracle.jdbc.driver.OracleCallableStatement</h1><pre>java.lang.Object | +----<a href="oracle.jdbc.driver.OracleStatement.html#_top_">oracle.jdbc.driver.OracleStatement</a> | +----<a href="oracle.jdbc.driver.OraclePreparedStatement.html#_top_">oracle.jdbc.driver.OraclePreparedStatement</a> | +----oracle.jdbc.driver.OracleCallableStatement</pre><hr><dl> <dt> public class <b>OracleCallableStatement</b> <dt> extends <a href="oracle.jdbc.driver.OraclePreparedStatement.html#_top_">OraclePreparedStatement</a> <dt> implements CallableStatement</dl>Oracle callable statement.<p><hr><a name="index"></a><h2> <img src="images/method-index.gif" width=207 height=38 alt="Method Index"></h2><dl> <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#addBatch()"><b>addBatch</b></a>() <dd> Add a set of parameters to the batch. <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#clearParameters()"><b>clearParameters</b></a>() <dd> <P>In general, parameter values remain in force for repeated use of aStatement. <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#getArray(int)"><b>getArray</b></a>(int) <dd> <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#getARRAY(int)"><b>getARRAY</b></a>(int) <dd> <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#getAsciiStream(int)"><b>getAsciiStream</b></a>(int) <dd> <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#getBFILE(int)"><b>getBFILE</b></a>(int) <dd> <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#getBigDecimal(int)"><b>getBigDecimal</b></a>(int) <dd> <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#getBigDecimal(int, int)"><b>getBigDecimal</b></a>(int, int) <dd> <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#getBinaryStream(int)"><b>getBinaryStream</b></a>(int) <dd> <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#getBlob(int)"><b>getBlob</b></a>(int) <dd> <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#getBLOB(int)"><b>getBLOB</b></a>(int) <dd> <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#getBoolean(int)"><b>getBoolean</b></a>(int) <dd> <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#getByte(int)"><b>getByte</b></a>(int) <dd> <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#getBytes(int)"><b>getBytes</b></a>(int) <dd> <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#getCHAR(int)"><b>getCHAR</b></a>(int) <dd> <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#getCLOB(int)"><b>getCLOB</b></a>(int) <dd> <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#getClob(int)"><b>getClob</b></a>(int) <dd> <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#getCursor(int)"><b>getCursor</b></a>(int) <dd> <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#getCustomDatum(int, oracle.sql.CustomDatumFactory)"><b>getCustomDatum</b></a>(int, CustomDatumFactory) <dd> <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#getDATE(int)"><b>getDATE</b></a>(int) <dd> <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#getDate(int)"><b>getDate</b></a>(int) <dd> <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#getDate(int, java.util.Calendar)"><b>getDate</b></a>(int, Calendar) <dd> <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#getDouble(int)"><b>getDouble</b></a>(int) <dd> <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#getFloat(int)"><b>getFloat</b></a>(int) <dd> <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#getInt(int)"><b>getInt</b></a>(int) <dd> <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#getLong(int)"><b>getLong</b></a>(int) <dd> <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#getNUMBER(int)"><b>getNUMBER</b></a>(int) <dd> <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#getObject(int)"><b>getObject</b></a>(int) <dd> <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#getObject(int, java.util.Dictionary)"><b>getObject</b></a>(int, Dictionary) <dd> <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#getOracleObject(int)"><b>getOracleObject</b></a>(int) <dd> <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#getRAW(int)"><b>getRAW</b></a>(int) <dd> <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#getREF(int)"><b>getREF</b></a>(int) <dd> <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#getRef(int)"><b>getRef</b></a>(int) <dd> <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#getROWID(int)"><b>getROWID</b></a>(int) <dd> <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#getShort(int)"><b>getShort</b></a>(int) <dd> <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#getString(int)"><b>getString</b></a>(int) <dd> <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#getSTRUCT(int)"><b>getSTRUCT</b></a>(int) <dd> <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#getTime(int)"><b>getTime</b></a>(int) <dd> <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#getTime(int, java.util.Calendar)"><b>getTime</b></a>(int, Calendar) <dd> <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#getTimestamp(int)"><b>getTimestamp</b></a>(int) <dd> <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#getTimestamp(int, java.util.Calendar)"><b>getTimestamp</b></a>(int, Calendar) <dd> <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#getUnicodeStream(int)"><b>getUnicodeStream</b></a>(int) <dd> <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#registerOutParameter(int, int)"><b>registerOutParameter</b></a>(int, int) <dd> <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#registerOutParameter(int, int, int)"><b>registerOutParameter</b></a>(int, int, int) <dd> <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#registerOutParameter(int, int, int, int)"><b>registerOutParameter</b></a>(int, int, int, int) <dd> Special Oracle version of registerOutParameter for registeringCHAR, VARCHAR, LONG, RAW and LONG RAW columns. <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#registerOutParameter(int, int, java.lang.String)"><b>registerOutParameter</b></a>(int, int, String) <dd> Special Oracle version of registerOutParameter for registeringObject columns. <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#sendBatch()"><b>sendBatch</b></a>() <dd> Send the sets of parameters batched (for Oracle-style batching only). <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#setExecuteBatch(int)"><b>setExecuteBatch</b></a>(int) <dd> Set the batch value (for Oracle-style batching only). <dt> <img src="images/red-ball-small.gif" width=6 height=6 alt=" o "> <a href="#wasNull()"><b>wasNull</b></a>() <dd> </dl><a name="methods"></a><h2> <img src="images/methods.gif" width=151 height=38 alt="Methods"></h2><a name="registerOutParameter(int, int, java.lang.String)"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a><a name="registerOutParameter"><b>registerOutParameter</b></a><pre> public synchronized void registerOutParameter(int paramIndex, int sqlType, String sqlName) throws SQLException</pre><dl> <dd> Special Oracle version of registerOutParameter for registeringObject columns.<p> <dd><dl> <dt> <b>Parameters:</b> <dd> paramIndexparameter - index. <dd> sqlTypeuse - OracleTypes.STRUCT, OracleTypes.ARRAY, orOracleTypes.REF. <dd> sqlNameSQL - name of the object. <dt> <b>Throws:</b> SQLException <dd> if sqlType is invalid, or an error occurred. </dl></dd></dl><a name="registerOutParameter(int, int, int, int)"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a><a name="registerOutParameter"><b>registerOutParameter</b></a><pre> public synchronized void registerOutParameter(int paramIndex, int sqlType, int scale, int maxLength) throws SQLException</pre><dl> <dd> Special Oracle version of registerOutParameter for registeringCHAR, VARCHAR, LONG, RAW and LONG RAW columns.<p> <dd><dl> <dt> <b>Parameters:</b> <dd> paramIndexparameter - index (the first parameter is 1). <dd> sqlTypetype - of the bind parameter, <dd> scalenot - used. <dd> maxLengthmaximum - length of the column. If not specified,maximum length allowed for that type is used. </dl></dd></dl><a name="setExecuteBatch(int)"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a><a name="setExecuteBatch"><b>setExecuteBatch</b></a><pre> public synchronized void setExecuteBatch(int nrows) throws SQLException</pre><dl> <dd> Set the batch value (for Oracle-style batching only).<p>Oracle-style batching is not supported for a callable statement.This method always sets the batch value to 1.<p> <dd><dl> <dt> <b>Overrides:</b> <dd> <a href="oracle.jdbc.driver.OraclePreparedStatement.html#setExecuteBatch(int)">setExecuteBatch</a> in class <a href="oracle.jdbc.driver.OraclePreparedStatement.html#_top_">OraclePreparedStatement</a> </dl></dd></dl><a name="sendBatch()"><img src="images/red-ball.gif" width=12 height=12 alt=" o "></a><a name="sendBatch"><b>sendBatch</b></a><pre> public synchronized int sendBatch() throws SQLException</pre><dl> <dd> Send the sets of parameters batched (for Oracle-style batching only).<p>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -