http://blog.csdn.net/caomiao2006/article/details/12972347
“如果不用指示变量在SELECT或FETCH语句中将一个NULL值赋给宿主变量时，Oracle会报1405错误。”
一句话，就是不能把NULL赋值给定义的变量。
nvl(b.NotifyPeopleID,'') //仍然错误！
nvl(b.NotifyPeopleID,'0') //正确
nvl(b.NotifyPeopleID,\"\") //错误 ORA-01741: illegal zero-length identifier
阅读(1512) | 评论(0) | 转发(0) |
