Oracle Fusion Middleware Java API Reference for Oracle Extension SDK Reference
11g Release 1 (11.1.1)

E13403-04

oracle.javatools.db.execute
Class PlSqlWrapper.PlSqlRunnable

java.lang.Object
  extended by oracle.javatools.db.execute.PlSqlWrapper.PlSqlRunnable
All Implemented Interfaces:
QueryWrapper.QueryRunnable
Enclosing class:
PlSqlWrapper

public abstract static class PlSqlWrapper.PlSqlRunnable
extends java.lang.Object
implements QueryWrapper.QueryRunnable

Runnable passed to the PlSqlWrapper to process the ResultSet and/or CallableStatement during execution. The processing is done via a separate class so that any work done on the database is managed appropriately (i.e. not on the event thread), and it also allows the wrapper framework to correctly close the Statement and ResultSet when done.

See Also:
PlSqlWrapper.executePlSql(PlSqlRunnable)

Constructor Summary
PlSqlWrapper.PlSqlRunnable()
           
 
Method Summary
 void prepareCall(java.sql.CallableStatement cs)
          Called once the statement has been created, but before execution so that any output parameters can be registered.
 void processCall(java.sql.CallableStatement cs)
           
 void processResultSet(java.sql.ResultSet rs)
          Iterate through the result set as appropriate.
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Constructor Detail

PlSqlWrapper.PlSqlRunnable

public PlSqlWrapper.PlSqlRunnable()
Method Detail

prepareCall

public void prepareCall(java.sql.CallableStatement cs)
                 throws java.sql.SQLException,
                        DBException
Called once the statement has been created, but before execution so that any output parameters can be registered. Input parameters are processed automatically assuming they were passed to the PlSqlWrapper constructor.

Parameters:
cs -
Throws:
java.sql.SQLException
DBException

processCall

public void processCall(java.sql.CallableStatement cs)
                 throws java.sql.SQLException,
                        DBException
Throws:
java.sql.SQLException
DBException

processResultSet

public void processResultSet(java.sql.ResultSet rs)
                      throws DBException
Description copied from interface: QueryWrapper.QueryRunnable
Iterate through the result set as appropriate. Use the wrapper's throwDBException method(s) to process any exceptions encountered during processing.

Specified by:
processResultSet in interface QueryWrapper.QueryRunnable
Parameters:
rs - the results of the query being m_run
Throws:
DBException - for any db (or processing) error

Oracle Fusion Middleware Java API Reference for Oracle Extension SDK Reference
11g Release 1 (11.1.1)

E13403-04

Copyright © 1997, 2010, Oracle. All rights reserved.