create or replace trigger tri_ins2
before insert on sc
for each row
declare
tri_sno varchar2(30);
tri_cno varchar2(30);
begin
select sno,cno into tri_sno,tri_cno from sc where grade between 0 and 100;
if(:new.sno = tri_sno and :new.cno=tri_cno and :new.grade in(0,100)) then dbms_output.put_line('您已成功插入一條資料!');
else
dbms_output.put.line('查不到學生資訊，請重新輸入!');
end if;
end tri_ins2;
8/1 PL/SQL: Statement ignored
8/17 PLS-00225: 子程式或游標 'PUT' 參考超出范圍
SQL>
這個錯誤不會改了，大家幫幫我
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/29642.html
標籤：疑難問題
上一篇：PSCAD