小弟想请高手帮忙,指出我该如何修改错误,最好帮忙写出代码,谢谢!
create or replace procedure add_values
(
INCOME_OUT OUT TEST1.INCOME%TYPE)
is
INCOME NUMBER;
salary number :=1000;
cursor values_cur
is select INCOME+salary FROM DLYYSW.TEST1 WHERE NAME LIKE 'ZHDN'||'%';
values_rec values_cur%ROWTYPE;
begin
OPEN values_cur;
FETCH values_cur INTO values_rec;
IF values_cur%NOTFOUND
THEN
MESSAGE
('NO NAME FOUND WITH NAME LIKE ZHDN .');
ELSE
INCOME_OUT := values_rec.INCOME;
MESSAGE
('THE PEOPLE NAMED ZHDN HAS " '||INCOME_OUT||'POUNDS.');
CLOSE values_cur;
END IF;
end add_values;错误: PLS-00201: 必须说明标识符 'MESSAGE'
行: 15
文本: MESSAGE错误: PL/SQL: Statement ignored
行: 15
文本: MESSAGE错误: PLS-00302: 必须说明 'INCOME' 组件
行: 18
文本: INCOME_OUT := values_rec.INCOME;错误: PL/SQL: Statement ignored
行: 18
文本: INCOME_OUT := values_rec.INCOME;错误: PLS-00201: 必须说明标识符 'MESSAGE'
行: 20
文本: MESSAGE错误: PL/SQL: Statement ignored
行: 20
文本: MESSAGE数据库的名字是TEST1
具体的样子是这样的:
ID NAME INCOME
1 RAMMAR XP 2000
2 LINDA ZHDN 50000
create or replace procedure add_values
(
INCOME_OUT OUT TEST1.INCOME%TYPE)
is
INCOME NUMBER;
salary number :=1000;
cursor values_cur
is select INCOME+salary FROM DLYYSW.TEST1 WHERE NAME LIKE 'ZHDN'||'%';
values_rec values_cur%ROWTYPE;
begin
OPEN values_cur;
FETCH values_cur INTO values_rec;
IF values_cur%NOTFOUND
THEN
MESSAGE
('NO NAME FOUND WITH NAME LIKE ZHDN .');
ELSE
INCOME_OUT := values_rec.INCOME;
MESSAGE
('THE PEOPLE NAMED ZHDN HAS " '||INCOME_OUT||'POUNDS.');
CLOSE values_cur;
END IF;
end add_values;错误: PLS-00201: 必须说明标识符 'MESSAGE'
行: 15
文本: MESSAGE错误: PL/SQL: Statement ignored
行: 15
文本: MESSAGE错误: PLS-00302: 必须说明 'INCOME' 组件
行: 18
文本: INCOME_OUT := values_rec.INCOME;错误: PL/SQL: Statement ignored
行: 18
文本: INCOME_OUT := values_rec.INCOME;错误: PLS-00201: 必须说明标识符 'MESSAGE'
行: 20
文本: MESSAGE错误: PL/SQL: Statement ignored
行: 20
文本: MESSAGE数据库的名字是TEST1
具体的样子是这样的:
ID NAME INCOME
1 RAMMAR XP 2000
2 LINDA ZHDN 50000
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货