比如:
create or replace procedure Output is
begin
spool C:\test.txt;
select SYSDATE from dual;
spool off;
end Output;这个是编译不过去的,如何实现这个功能?
create or replace procedure Output is
begin
spool C:\test.txt;
select SYSDATE from dual;
spool off;
end Output;这个是编译不过去的,如何实现这个功能?
begin
execute immediate 'spool C:\test.txt; select SYSDATE from dual; spool off;'
end Output;
execute immediate 'spool C:\test.txt; select SYSDATE from dual; spool off;'