oracle Plsql SQL窗口执行存储过程出错00900

Question

创建存储过程语句：
create procedure MailingListCount(
ListCount OUT INTERGER
)
IS
v_row INTERGER;
BEGIN
select count(*) INTO v_rows
FROM Customers
WHERE NOT cust_eamil IS NULL;
ListCont :=v_rows;
END;
执行存储过程语句：
var ReturnValue NUMBER
EXEC MailingListCount(:ReturnValue);
SELECT ReturnValue;
执行环境：PL/SQL SQL窗口
报错信息：
ora-00900:invalid sql statement

ora-00923:FROM keword not found where expected

Answer 1

WHERE NOT cust_eamil IS NULL; 这句语法错误！应该是WHERE cust_eamil IS NOT NULL;