以下是我的存储过程
create or replace procedure tempprocedure as
tempdate tempuser.testtable.currentdate%type;
begin
select HIREDATE into tempdate from scott.emp where EMPNO=7521;
dbms_output.put_line(to_char(tempdate));
end;执行其中的sql是有值的,如下
SQL> select HIREDATE from scott.emp where EMPNO=7521;
HIREDATE
-----------
1981-2-22现在我执行该存储过程
SQL> exec tempprocedure;
PL/SQL procedure successfully completed为什么没有出现具体的值,即为什么看不到1981-2-22
create or replace procedure tempprocedure as
tempdate tempuser.testtable.currentdate%type;
begin
select HIREDATE into tempdate from scott.emp where EMPNO=7521;
dbms_output.put_line(to_char(tempdate));
end;执行其中的sql是有值的,如下
SQL> select HIREDATE from scott.emp where EMPNO=7521;
HIREDATE
-----------
1981-2-22现在我执行该存储过程
SQL> exec tempprocedure;
PL/SQL procedure successfully completed为什么没有出现具体的值,即为什么看不到1981-2-22
set serveroutput on然后再执行你的过程.
set serveroutput on