CREATE
OR REPLACE PROCEDURE printUserInfo (
upwd IN USERINFO.USERWORD % TYPE,
uname out USERINFO.USERNAME % TYPE
) AS userNum NUMBER ;
BEGIN
SELECT
COUNT (*) INTO userNum
FROM
USERINFO
WHERE
USERWORD = upwd ;
IF userNum > 0 THEN
SELECT
username INTO uname
FROM
USERINFO
WHERE
USERWORD = upwd ;
ELSE
dbms_output.put_line ('无此用户') ;
END IF ;
END ;
这个存储过程显示 if那句话有错 但是不知道哪错了 谁能回答啊 帮我解决啊