| saving file [message #432435] |
Tue, 24 November 2009 04:08  |
kuwait
Messages: 55
Registered: October 2007
|
Member |
|
|
Hello,
Please can you help me I want to create a button to copy a file (i.e. PDF file) from a client pc into a shared server folder
is there a pl/sql code capable of doing that?
Thanks
|
|
|
|
|
|
|
|
| Re: saving file [message #433389 is a reply to message #433367] |
Wed, 02 December 2009 01:12  |
kuwait
Messages: 55
Registered: October 2007
|
Member |
|
|
Thanks I solved it this was the solution:
declare
filename VARCHAR2(600);
begin
filename:=GET_FILE_NAME('C:\', NULL, 'PDF Files (*.pdf)|*.pdf|', NULL, OPEN_file, TRUE);
HOST('Y:\DO_COPY.BAT "'||filename||'" "'||'Z:\'||'" /V /Y' );
if form_success then
message(filename);
end if;
end;
I created a bat file which contains the following code:
|
|
|
|
| Re: saving file [message #434458 is a reply to message #433389] |
Wed, 09 December 2009 05:56 |
lancer26
Messages: 52
Registered: May 2006
Location: Pakistan
|
Member |
|
|
dear, can u more explain batch file...
i also have same problem
i m using following..but it works for some files and ignored others.
DECLARE
RS VARCHAR2(200);
BEGIN
RS := 'COPY '||:REF_FILE||' Z:\'||:CUSTOMER_ORDER.TRANS_ID||'.XLS';
MESSAGE(RS);
HOST(RS);
END;
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
