1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33
| function loggin (
loggin varchar2,
password varchar2
)
return number is
cursor c_verif_loggin ( c_loggin number,
c_password number) is
select
id
from
t_loggin
where c_loggin = loggin and c_password = password;
id_loggin number;
lError PLS_INTEGER;
begin
open c_verif_loggin (loggin, password);
fetch c_verif_loggin into id_loggin;
close c_verif_loggin;
exception
when no_data_found then
raise_application_error(-20803,'problème de loggin');
when others then
lError := SQLCODE;
return lError;
end loggin; |
Partager