Oracle提供的Utl_File报如何使用???
我写了一个存储过程,如下
create or replace procedure Pr_Save_To_Text is
MyHandle Utl_File.File_Type;
vPath Varchar2( 20 );
vName Varchar2( 20 );
begin
vPath := 'D:\';
vName := 'Data.Txt';
Begin
MyHandle := Utl_File.FOpen( vPath, vName, 'a' );
For Cur In ( Select * From Plusmoney )
Loop
Utl_File.Put_Line( MyHandle,
Cur.CZ_NO||','||
Cur.PhoneNo||','||
To_Char( Cur.JE )||','||
To_Char( Cur.CZ_Date, 'YYYYMMDD' )||','||
Cur.CZ_LTNO||','||
Cur.DQH||','||
To_Char( Cur.Play_Mode )||','||
Cur.QH
);
End Loop;
Exception
When UTL_FILE.INVALID_PATH Then
Return;
When UTL_FILE.INVALID_MODE Then
Return;
When UTL_FILE.INVALID_OPERATION Then
Return;
End;
Utl_File.FClose( MyHandle );
end Pr_Save_To_Text;
但是总是产生UTL_FILE.INVALID_PATH的异常,这是为什么???