Question

oracle存储过程中带空值的输入怎么写？COALESCE()函数用错了吗？

(start_time in date,end_time in date,name in nvarchar2,tname in nvarchar2,cusers out sys_refcursor)
as

begin

open cusers for select * from C_USERS where logintime >= COALESCE(start_time,logintime)
and logintime <= COALESCE(end_time,logintime)
and username = COALESCE(name,username)
and truename = COALESCE(tname,truename);

end;
编译提示错误：
Line # = 6 Column # = 17 Error Text = PL/SQL: SQL Statement ignored
Line # = 9 Column # = 71 Error Text = PL/SQL: ORA-12704: 字符集不匹配

Answer 1

空值 ，你直接用NVL不就行了.
open cusers for select * from C_USERS where logintime >= NVL(start_time,logintime)
and logintime <= NVL(end_time,logintime)
and username = NVL(name,username)
and truename = NVL(tname,truename);

追问

是这样的，谢谢

追答

System.out.println("是的");