CREATE OR REPLACE PROCEDURE PROC_HR_ISNEWUSER(handphone in varchar2,user_count OUT number)
AS BEGIN
SELECT count(1) into user_count
FROM HR_USER
WHERE mobile=handphone
and status<>9;
END PROC_HR_ISNEWUSER;这里那里错了?
提示错误:行号=1 列号=30 错误文本=PLS-00103出现”create"在需要下列之一时: (; is with authid as cluster compress order
AS BEGIN
SELECT count(1) into user_count
FROM HR_USER
WHERE mobile=handphone
and status<>9;
END PROC_HR_ISNEWUSER;这里那里错了?
提示错误:行号=1 列号=30 错误文本=PLS-00103出现”create"在需要下列之一时: (; is with authid as cluster compress order
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货