com.caucho.quercus.lib.db
Class OracleStatement

java.lang.Object
  extended by com.caucho.quercus.lib.db.JdbcStatementResource
      extended by com.caucho.quercus.lib.db.OracleStatement

public class OracleStatement
extends JdbcStatementResource

Oracle statement class. Since Oracle has no object oriented API, this is essentially a JdbcStatementResource.


Method Summary
 java.lang.Integer getBindingVariable(java.lang.String name)
          Returns a binding variable index
 java.util.HashMap<java.lang.String,java.lang.Integer> getBindingVariables()
          Returns all binding variables
 Value getByNameVariable(java.lang.String name)
          Returns the variable value by name
 java.util.HashMap<java.lang.String,Value> getByNameVariables()
          Returns all variable names and corresponding values
protected  java.sql.CallableStatement getCallableStatement()
          Gets the underlying callable statement.
protected  int getFetchedRows()
          Gets the number of fetched rows.
protected  OracleOciLob getOutParameter()
          Gets the out parameter.
 Value getResultBuffer()
          Returns the internal result buffer
protected  int increaseFetchedRows()
          Increases the number of fetched rows.
 void putBindingVariable(java.lang.String name, java.lang.Integer value)
          Assigns a variable name to the corresponding index
 void putByNameVariable(java.lang.String name, Value value)
          Assigns a value to a variable
 java.lang.Integer removeBindingVariable(java.lang.String name)
          Removes a binding variable
 Value removeByNameVariable(java.lang.String name)
          Removes a variable given the corresponding name
 void resetBindingVariables()
          Removes all binding variables
 void resetByNameVariables()
          Removes all variables
protected  void setOutParameter(OracleOciLob outParameter)
          Sets the out parameter.
 void setResultBuffer(Value resultBuffer)
          Sets the internal result buffer
 
Methods inherited from class com.caucho.quercus.lib.db.JdbcStatementResource
bindParams, bindResults, close, dataSeek, errorCode, errorMessage, execute, executeStatement, fetch, freeResult, getFieldCount, getJavaConnection, getMetaData, getNumRows, getParam, getParamLength, getPreparedStatement, getResultMetadata, getResultSet, getStatementType, paramCount, prepare, prepareStatement, setObject, setPreparedStatement, setResultSet, toString, validateConnection
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait
 

Method Detail

putBindingVariable

public void putBindingVariable(java.lang.String name,
                               java.lang.Integer value)
Assigns a variable name to the corresponding index

Parameters:
name - the variable name
value - the corresponding index

getBindingVariable

public java.lang.Integer getBindingVariable(java.lang.String name)
Returns a binding variable index

Parameters:
name - the variable name
Returns:
the binding variable index

removeBindingVariable

public java.lang.Integer removeBindingVariable(java.lang.String name)
Removes a binding variable

Parameters:
name - the binding variable name
Returns:
the binding variable index

getBindingVariables

public java.util.HashMap<java.lang.String,java.lang.Integer> getBindingVariables()
Returns all binding variables

Returns:
a HashMap of variable name to index values

resetBindingVariables

public void resetBindingVariables()
Removes all binding variables


setResultBuffer

public void setResultBuffer(Value resultBuffer)
Sets the internal result buffer


getResultBuffer

public Value getResultBuffer()
Returns the internal result buffer

Returns:
the result buffer

putByNameVariable

public void putByNameVariable(java.lang.String name,
                              Value value)
Assigns a value to a variable

Parameters:
name - a variable name
value - the variable value

getByNameVariable

public Value getByNameVariable(java.lang.String name)
Returns the variable value by name

Parameters:
name - the variable name
Returns:
the variable value

removeByNameVariable

public Value removeByNameVariable(java.lang.String name)
Removes a variable given the corresponding name

Parameters:
name - the variable name
Returns:
the variable value

getByNameVariables

public java.util.HashMap<java.lang.String,Value> getByNameVariables()
Returns all variable names and corresponding values

Returns:
a HashMap of variable names to corresponding values

resetByNameVariables

public void resetByNameVariables()
Removes all variables


increaseFetchedRows

protected int increaseFetchedRows()
Increases the number of fetched rows.

Returns:
the new number of fetched rows

getCallableStatement

protected java.sql.CallableStatement getCallableStatement()
Gets the underlying callable statement.


getFetchedRows

protected int getFetchedRows()
Gets the number of fetched rows.

Returns:
the number of fetched rows

getOutParameter

protected OracleOciLob getOutParameter()
Gets the out parameter.

Returns:
the out parameter

setOutParameter

protected void setOutParameter(OracleOciLob outParameter)
Sets the out parameter.

Parameters:
outParameter - the new out parameter