i am unable to call my stored function (in oracle 8.1.5) from visual studio.net
but the same function i am able to call if the server is oracle 8.1.7
what may be the problem
CREATE OR REPLACE FUNCTION funCheckUser(varUserID USER.USER_ID%type,varPassword USER.PASSWORD%type)
RETURN int
is
varCount int;
begin
select count(*) into varCount from USER where USER_ID = varUserID and PASSWORD = varPassword;
if varCount = 1 then
return 1;
else return 0;
end if;
end funCheckUser;