我在 存储过程 中要设置路径,怎么办?谁能帮我更改以下 ORACLE 程序:Procedure PRO_OutputLog ( sUser IN VARCHAR2, sComp IN VARCHAR2, sMsgID IN VARCHAR2 ) IS tjcw_logPath varchar2; begin select name into tjcw_logPath from v$parameter where name = 'background_dump_dest'; alter system set utl_file_dir = tjcw_logPath ; utl_file.fopen('C:\tjcw_log.log','W'); dbms_output.put_line(sUser '||' sComp '||' sMsgID ); utl_file.fclose(':alert_loc'); end ;
Procedure PRO_OutputLog ( sUser IN VARCHAR2, sComp IN VARCHAR2, sMsgID IN VARCHAR2 ) IS tjcw_logPath varchar2(100); str varchar2(50); begin select name into tjcw_logPath from v$parameter where name = 'background_dump_dest'; str:='alter system set utl_file_dir ='||tjcw_logPath ; execute immediate str; utl_file.fopen(tjcw_logPath,'tjcw_log.log','W'); dbms_output.put_line(sUser '||' sComp '||' sMsgID ); utl_file.fclose(':alert_loc'); end ;
( sUser IN VARCHAR2,
sComp IN VARCHAR2,
sMsgID IN VARCHAR2 )
IS
tjcw_logPath varchar2;
begin
select name into tjcw_logPath
from v$parameter
where name = 'background_dump_dest';
alter system set utl_file_dir = tjcw_logPath ;
utl_file.fopen('C:\tjcw_log.log','W');
dbms_output.put_line(sUser '||' sComp '||' sMsgID );
utl_file.fclose(':alert_loc');
end ;
( sUser IN VARCHAR2,
sComp IN VARCHAR2,
sMsgID IN VARCHAR2 )
IS
tjcw_logPath varchar2(100);
str varchar2(50);
begin
select name into tjcw_logPath
from v$parameter
where name = 'background_dump_dest'; str:='alter system set utl_file_dir ='||tjcw_logPath ;
execute immediate str;
utl_file.fopen(tjcw_logPath,'tjcw_log.log','W');
dbms_output.put_line(sUser '||' sComp '||' sMsgID );
utl_file.fclose(':alert_loc');
end ;