Dear master oracle

saya ada masalah dalam penggunaan webutil.

saya buat trigger yg akan menyimpan file dari client ke folder di application 
server.

berikut scriptnya :
DECLARE
   v_file        VARCHAR2 (300) := NULL;
   client_file   VARCHAR2 (150);
   server_file   VARCHAR2 (150);
   blnret        BOOLEAN;
   v_size        NUMBER;
BEGIN
:ctr.txt_doc_name :=
      webutil_file.file_selection_dialog 
(directory_name      => 'C:\',
 file_name           => NULL,
 file_filter         => '*.*',
 title               => 'Select File to LOAD',
 dialog_type         => open_file,
 select_file         => TRUE
 );

v_file := SUBSTR (:ctr.txt_doc_name, INSTR (:ctr.txt_doc_name, '\', -1) + 1);

client_file := :ctr.txt_doc_name;
server_file := '/file_transfer/' || v_file;

blnret := webutil_file_transfer.client_to_as_with_progress                      
(client_file, server_file, 'Proses transfer', '', TRUE, NULL );

         IF blnret
         THEN
            message_box ('MSG_INFO', 'file copied');           
         ELSE
            message_box ('MSG_INFO', 'transfer failed');
         END IF;
END;

yang jadi masalah, ada beberapa file yg gagal di transfer. 
bagaimana cara saya mengetahui kenapa file tersebut gagal di transfer ?

Terima kasih

ferland


Kirim email ke