sql脚本如下:
select operatorUser 签派员,
GetFlightReleaseCancel(${startDate},${endDate},${operatorName}) 个人放行取消航班,
GetReleaseAlternateReturn('VC',${startDate},${endDate},${operatorName}) 个人放行备降航班,
GetReleaseAlternateReturn('RC',${startDate},${endDate},${operatorName}) 个人放行返航航班 ,
GetReleaseNormalFlights(${startDate},${endDate},${operatorName}) 个人放行正常航班,
GetReleaseAllFlights(${startDate},${endDate},${operatorName}) 个人放行所有航班,
GetReleaseNormalRate(${startDate},${endDate},${operatorName})||'%' 个人签派放行正常率,
GetAlternateReturnRate${startDate},${endDate},${operatorName})||'%' 个人返航备降率,
GetReleaseNormalFlightsRate(${startDate},${endDate},${operatorName})||'%' 放行正常率,
GetReleaseAbnormalFlights(${startDate},${endDate},${operatorName}) 不正常航班,
GetReleaseDelayNormalFlights(${startDate},${endDate},${operatorName}) 延误放行正常
from V_Dispatchers_Release group by operatorUser
${startDate},${endDate},${operatorName}是自定义的模板参数。在调用自定义函数传参时出现异常信息如下:
发生的问题是:错误代码:1301 数据集配置错误Query:ORA-00936: 缺失表达式。