The create or replace procedure find_student (studentName varchar2, student_count number)
As
The begin
Select count (*) into student_count from students where student_name=studentName;
If student_count & gt; 0 then
Dbms_output. Put_line (' were found '| | student_count | |', '| | studentName | |' students');
The else
Dbms_output. Put_line (' not found is called '| | studentName | |' students');
end if;
end;


Show the error:
7/1 of the pl/SQL: SQL statement ignored
Pl/SQL 7/41: ORA - 00945 table or view there is no
I don't have to build student table is a great god first error is what mean?

CodePudding user response:

students

Pl/SQL 7/41: ORA - 00945 table or view there is no

CodePudding user response:

Stored procedures to create statement is illegal, be ignored,