SQL statements below
The CREATE OR REPLACE PROCEDURE SCOTT. Proc_emp
AS
Row_emp SCOTT. EMP % rowtype;
The BEGIN
FOR row_emp IN (SELECT * FROM SCOTT. The EMP)
Loop
Dbms_output. Put_pline (' name: '| | row_emp, ename | |' position is: '| | row_emp. Job)
END loop;
END;

error:
(Err) ORA - 24344: success with compilation error

CodePudding user response:

Dbms_output. Put_line (' name: '| | row_emp, ename | |' position is: '| | row_emp. The job);

Two problems, the end is missing a ";" Semicolons, put_line write wrong,

CodePudding user response:

Upstairs, positive solutions, more row_emp variables are not defined, as follows:

 CREATE OR REPLACE PROCEDURE proc_emp AS 
The BEGIN 
FOR row_emp IN (SELECT * FROM Scott. The emp) LOOP 
Dbms_output. Put_line (' name: '| | row_emp, ename | |' position is: '| | row_emp. The job); 
END LOOP; 
END;