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!

how to add file in my local drive

India_vigneshApr 25 2016 — edited Apr 25 2016

hi

im designing a form to keep track offer status.

When i click browse button i have written code to get file from any location as given below code.

DECLARE

filename VARCHAR2(256);

BEGIN filename := GET_FILE_NAME(File_Filter=> 'DOC Files (*.doc)|*.doc|');

:AATE_OFFER.TEXT_ITEM37 := filename;

end;

 lets say file taken is from **E:\\files\\vignesh.doc**

My requirement is after selecting file when i give save button it should save only in my D:\company\offerletter path, with file name as offer_101.doc (this offer_101 where 101 is my empu_code so it should automatically take that value from text item empu_code) is it possible ??

pls help me with code

pastedImage_0.png

Thanks

Vignesh

This post has been answered by Manu. on Apr 25 2016
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 23 2016
Added on Apr 25 2016
6 comments
922 views