过程里面不能直接写一个查询语句.
create or replace procedure proc_test
is
v_deptno dz_dept%rowtype;
begin
select deptno into v_deptno from dz_dept_tbl;
end;
create or replace procedure proc_test
is
v_deptno dz_dept%rowtype;
begin
select deptno into v_deptno from dz_dept_tbl;
end;
create or replace procedure proc_test
is
v_deptno dz_dept.deptno%type;
begin
select deptno into v_deptno from dz_dept_tbl;
end;
out.sys.print()好像是这么写的,你找一下吧。