This is the coding pasted in: println("instPidm: ${newInstPidm}, termCode: ${params.termCode}, CRN: ${params.crn}")
println("instrApprvdTchGradCrs: ${personIsInstructor.instrApprvdTchGradCrs[0]}")
def canInstructorBeAssignedCourse(params) {
Sql sql = new groovy.sql.Sql(dataSource)
def results = ''
try {
sql.call("{call ouregistrar.thebook.instr_canbe_assigned_crs(?,?,?,?,?)}",
[ newInstPidm
, params.termCode
, personIsInstructor.instrApprvdTchGradCrs[0]
, params.crn
, Sql.out(Sql.VARCHAR.type)
]) { message ->
results = message
//if (results != 'Y') {
// return results + newInstPidm
// }
}
}
catch (ex) {
log.error("""ERROR-ScheduleUpdateService - canInstructorBeAssignedCourse \n
Exception: ${ex.getStackTrace()}""")
results = "Error checking if can assign course for " + newInstPidm
}
return results
}