• 認証スキームを作成します function my_authentication ( p_username in varchar2, p_password in varchar2 ) return boolean is l_user users.name%type := upper(p_username); l_pwd users.password%type := p_password; l_id users.id%type; begin select id,password into l_id, l_pwd from users where upper(name) = upper(l_user) and password = l_pwd; return true; exception when NO_DATA_FOUND then return false; end;