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 }