create or replace function f_check_login
(
user_code VARCHAR2,
user_pwd VARCHAR2
)
return BOOLEAN is
Result BOOLEAN;
begin
RETURN TRUE;
end f_check_login;
/*******以下是java代码
CallableStatement proc=conn.prepareCall("{?=call f_check_login(?,?)}");
proc.registerOutParameter(1,java.sql.Types.BOOLEAN);
proc.setString(2,loginName);
proc.setString(3,loginPass);提示:
java.sql.SQLException: 无效的列类型请问是哪里的错?
(
user_code VARCHAR2,
user_pwd VARCHAR2
)
return BOOLEAN is
Result BOOLEAN;
begin
RETURN TRUE;
end f_check_login;
/*******以下是java代码
CallableStatement proc=conn.prepareCall("{?=call f_check_login(?,?)}");
proc.registerOutParameter(1,java.sql.Types.BOOLEAN);
proc.setString(2,loginName);
proc.setString(3,loginPass);提示:
java.sql.SQLException: 无效的列类型请问是哪里的错?
(
user_code VARCHAR2,
user_pwd VARCHAR2
)
return BOOLEAN is
Result BOOLEAN;
begin
RETURN TRUE;
end f_check_login;
这个脚本能在数据库执行?