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