Declare an Op
import net.wgen.op.Op;
import net.wgen.op.OpException;
import net.wgen.op.db.CallExecutor;
import net.wgen.op.db.DatabaseCall;
import net.wgen.op.logging.TraceKey;
import oracle.jdbc.OracleTypes;
public BazOp extends Op
{
// inputs
private Long _fooInputSid = null;
private Long _barInputSid = null;
// output
private List _barResults = null;
public BazOp( TraceKey traceKey )
{
super( traceKey );
}
/**
* Execute the operation on the database.
*
* @throws OpException
*/
protected void _execute( WGCallExecutor exec )
throws OpException
{
DatabaseCall call = makeProcedure("sp_get_something");
call.setParameters( OracleTypes.CURSOR, new Object[] { _fooInputSid, _barInputSid } );
exec.executeWGDatabaseCall( call );
_barResults = (List) call.getParameter( 1 ).getValue();
}
// ... setters _fooInputSid _barInputSid
// ... getters _barResults
}