public DbParameterAccessor getDbParameterAccessor(String name,
Direction expectedDirection) throws SQLException{
DbParameterAccessor parameter = findAccessorForParamWithName(name);
if (parameter.hasDirection(INPUT_OUTPUT)) {
// clone, separate into input and output
parameter = parameter.clone();
parameter.setDirection(expectedDirection);
}
// sql server quirk. if output parameter is used in an input column,
// then the param should be cloned and remapped to IN/OUT
if (expectedDirection!=Direction.OUTPUT && parameter.hasDirection(Direction.OUTPUT)) {