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
...全文
6522打赏收藏
oracle在navicat中创建存储引擎报错。。。急救。
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 c
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;