PL/SQL: 8/1 Statement ignored8/17 PLS - 00225: a subroutine or cursor 'PUT' reference beyo-CodePudding

The create or replace the trigger tri_ins2
Before the insert on sc
For each row
Declare
Tri_sno varchar2 (30);
Tri_cno varchar2 (30);
The 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 (0100)) in then dbms_output. Put_line (' you have successfully inserted into a data! ');
The else
Do not check dbms_output. Put. The line (' student information, please enter again! ');
End the if;
End tri_ins2;

PL/SQL: 8/1 Statement ignored
8/17 PLS - 00225: a subroutine or cursor 'PUT' reference beyond the scope of the
SQL>

This mistake won't be changed, everybody to help me

CodePudding user response:

I like you is wrong, should such dbms_output. Out_line ();