SQL语句如下
CREATE OR REPLACE PROCEDURE SCOTT.proc_emp
AS
row_emp SCOTT.EMP%rowtype;
BEGIN
FOR row_emp IN(SELECT * FROM SCOTT.EMP)
loop
dbms_output.put_pline('姓名:'||row_emp.ename||' 职位是:'||row_emp.job)
END loop;
END;报的错误:
[Err] ORA-24344: success with compilation error
CREATE OR REPLACE PROCEDURE SCOTT.proc_emp
AS
row_emp SCOTT.EMP%rowtype;
BEGIN
FOR row_emp IN(SELECT * FROM SCOTT.EMP)
loop
dbms_output.put_pline('姓名:'||row_emp.ename||' 职位是:'||row_emp.job)
END loop;
END;报的错误:
[Err] ORA-24344: success with compilation error
CREATE OR REPLACE PROCEDURE proc_emp AS
BEGIN
FOR row_emp IN (SELECT * FROM scott.emp) LOOP
dbms_output.put_line('姓名:' || row_emp.ename || ' 职位是:' || row_emp.job);
END LOOP;
END;