create or replace function ch_height_pm(in_cid in number, in_name in varcher2) return number is
pm number;
ch_height number;
begin
select c.height into ch_height from children c
where c.cid=in_cid and in_name=c.name;
select count(1) into pm from children c
where c.cid=in_cid and in_name=c.name and c.height>ch_height;
pm:=pm+1;
return(pm);
exception
when no_data_found then
dbms_output.put_line('该学生的身高:'||p_in_courseid|| '的学生表中找不到');
end ch_height_pm;
FUNCTION SYS.CH_HEIGHT_PM 编译错误
错误:PLS-00201: 必须声明标识符 'VARCHER2'
行:1
文本:create or replace function ch_height_pm(in_cid in number, in_name in varcher2) return number is
错误:PL/SQL: Compilation unit analysis terminated
行:1
文本:create or replace function ch_height_pm(in_cid in number, in_name in varcher2) return number is