Newbie Pl/SQL Function

Hey all,

I dont know about pl/sql function,

i wrote a small code

please let me know if it is correct

CREATE FUNCTION LOGIN11_PEOPLE (USERN IN VARCHAR2, PASSW IN VARCHAR2) RETURN BOOLEAN IS
M_COUNT:=0;
BEGIN
SELECT COUNT(*) INTO M_COUNT FROM LOGIN WHERE USER_NAME=USERN AND PASS_WORD=PASSW;
IF M_COUNT=1 THEN
RETURN TRUE;
ELSE
RETURN FALSE;
END IF;
END;


this function takes two parameter username and password
and outputs a boolean true or false

how do i execute this fucntion in oracle

how to make sure that this code is running,

Plz

thanz

shah

I think you had a syntax error in your function.

CREATE FUNCTION LOGIN11_PEOPLE (USERN IN VARCHAR2, PASSW IN VARCHAR2) RETURN INTEGER IS
M_COUNT INTEGER;
BEGIN
SELECT COUNT(*) INTO M_COUNT FROM LOGIN WHERE USER_NAME=USERN AND PASS_WORD=PASSW;
RETURN M_COUNT;
END;
/
show errors;

select LOGIN11_PEOPLE('USERM', null) from dual;

drop FUNCTION LOGIN11_PEOPLE ;

instead of writing

create login

do create or replace function login.....