您所在位置：主题：这个存储过程有错吗?
admins
[专家分：0] 发布于 2007-10-28 16:17:00
//建表
create table salary_details
(
empcode varchar2(10),
workingdays number,
salary number
)
//建存储过程
create or replace procedure showsal(emp_code in varchar2(10))
is
mysal number;
begin
select (workingdays*salary)*0.95 into mysal from salary_details where empcode=emp_code;
dbms_output.put_line('净收入为:'||mysal);
EXCEPTION
WHEN NO_DATA_FOUND THEN
dbms_output.put_line('不存在此员工号!');
end;
//创建的时候总是出现 [color=FF0000]警告: 创建的过程带有编译错误。[/color]
create table salary_details
(
empcode varchar2(10),
workingdays number,
salary number
)
//建存储过程
create or replace procedure showsal(emp_code in varchar2(10))
is
mysal number;
begin
select (workingdays*salary)*0.95 into mysal from salary_details where empcode=emp_code;
dbms_output.put_line('净收入为:'||mysal);
EXCEPTION
WHEN NO_DATA_FOUND THEN
dbms_output.put_line('不存在此员工号!');
end;
//创建的时候总是出现 [color=FF0000]警告: 创建的过程带有编译错误。[/color]