webutil_file_transfer.client_to_db [message #477648] |
Sun, 03 October 2010 01:34 |
jai_g
Messages: 23 Registered: July 2009 Location: India
|
Junior Member |
|
|
Hi,
I have used webutil_file_transfer.Client_To_AS_with_progress to upload files from client to Application Server using Forms 10g.
However, now i want to save file in database and not upload to database as blob.
I mean I want to save the file from client TO a folder available in the database server.
Apart from the problem, I was wondering, there is no documentation available on WEBUTIL.
please help.
|
|
|
Re: webutil_file_transfer.client_to_db [message #477748 is a reply to message #477648] |
Mon, 04 October 2010 04:04 |
|
deepakmannazhi
Messages: 137 Registered: February 2010 Location: Dubai, UAE
|
Senior Member |
|
|
Hi Friend this may help you, webutil_file_transfer.client_to_as_with_progress.
the path should be shared to clients.if more doubts please get me in +9710567709356
DECLARE
CURSOR c_path
IS
SELECT attachpath
FROM path_table
WHERE apid = :parameter.apid;
file_name VARCHAR2 (500);
v_path VARCHAR2 (200);
v_name VARCHAR2 (1000);
v_doc VARCHAR2 (10);
BEGIN
file_name := client_get_file_name (NULL, NULL, 'All Files|*.*', NULL, open_file, TRUE );
OPEN c_path;
FETCH c_path INTO v_path;
CLOSE c_path;
v_doc := SUBSTR (file_name, INSTR (file_name, '.'));
v_name := v_path ||'document'|| v_doc;
IF webutil_file_transfer.client_to_as_with_progress(file_name,v_name,'Upload','File Uploading',FALSE, NULL)
THEN
NULL:
END IF;
END IF;
ELSE
NULL;
END IF;
END IF;
END;
thnkz and Regards
Deepak
[Updated on: Mon, 04 October 2010 09:12] Report message to a moderator
|
|
|
Re: webutil_file_transfer.client_to_db [message #477891 is a reply to message #477748] |
Tue, 05 October 2010 01:56 |
jai_g
Messages: 23 Registered: July 2009 Location: India
|
Junior Member |
|
|
Hi Dear,
My database server and application server are different i.e (database resides in one machine and application resides in another machine).
Whether your suggestion will solve my problem.
I hope this will save the file in application server only, but not in a folder which is available in the database server.
please suggest.
|
|
|
|
Re: webutil_file_transfer.client_to_db [message #478338 is a reply to message #477648] |
Thu, 07 October 2010 23:35 |
jai_g
Messages: 23 Registered: July 2009 Location: India
|
Junior Member |
|
|
Hi Dear,
I tried with shared folder available in application server. It works.Similarly I tried with shared folder available in database but it does not copy.Expecting your suggestion.
|
|
|
|
|