Skip to Main Content

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Rename File in Oracle Forms before Copy to another drive

G.YJan 9 2013 — edited Jan 9 2013
Dear All Seniors
I want to ask that how to rename file before copy it to other drive.
Actually when we get file from drive to open then it that time before copying I want to rename it.
------this code i am using for copying file from first path to other.
DECLARE
filename VARCHAR2(500);
BEGIN
filename := GET_FILE_NAME( File_Filter => 'Files (*.*)|*.*|');
READ_IMAGE_FILE(filename, 'any', 'IMAGE6');
HOST ('xcopy "'|| filename ||'" \\172.172.0.4\Combo_pic\',no_screen);
END;
I am using this code it is working fine, but i did't know how to use it before copying file.
host('cmd /c rename "'||:block3.file_name||'" " '||:block3.file_name_n||' " '); --- for file rename

thanks.
This post has been answered by HamidHelal on Jan 9 2013
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 6 2013
Added on Jan 9 2013
2 comments
1,614 views