create or replace procedure login(
2 Tellerno char, --!!!!
3 Tellerpwd char)
4 as
5 ttt char(12);
6 ttttt char(20);
7
8 begin
9 select telpwd into ttt from st_operinfo where TelNo=Tellerno;
10 if tellerpwd=ttt then
11 select TelName into ttttt from st_operinfo where TelNo=Tellerno;
12 end if;
13 end;
14 /
2 Tellerno char, --!!!!
3 Tellerpwd char)
4 as
5 ttt char(12);
6 ttttt char(20);
7
8 begin
9 select telpwd into ttt from st_operinfo where TelNo=Tellerno;
10 if tellerpwd=ttt then
11 select TelName into ttttt from st_operinfo where TelNo=Tellerno;
12 end if;
13 end;
14 /
create or replace procedure login(
2 Tellerno IN char, --缺少逗号
3 Tellerpwd IN char)
4 as
5 ttt char(12);
6 ttttt char(20);
7
8 begin
9 select telpwd into ttt from st_operinfo where TelNo=Tellerno;
10 if tellerpwd=ttt then
11 select TelName into ttttt from st_operinfo where TelNo=Tellerno;
12 end if;
13 end;
14 /