hi,
I have requirement to save image with voucher entry. Can you please guide which approach is good.
1. Save image in table as blob.
2. Save image in application directory and path to save in column.
regards,
Abdul Aqeel MalikProfessional
❇️ OrclQA.Com is a question and answer forum for programmers.
❇️ Here anyone can ask questions and anyone can answer to help others.
❇️ It hardly takes a minute to sign up and it is 100% FREE.
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
OrclQA.Com is a question and answer forum for programmers.
Here anyone can ask questions and anyone can answer to help others.
It hardly takes a minute to sign up and it is 100% FREE.
Vinish Kapoor
Simply create a form on that table and then change the item type of blob column to file browse item so that the user can upload the image. And when the user will click on the Apply Changes button your voucher data and image both will be saved.
Abdul Aqeel Malik
ok. thanks but is it ok if using 18c express database and many daily images to save in blob. because images may require much space. please advise
Vinish Kapoor
Yes, if database storage issues, then it is recommended that you store the BLOB to the file system. You can check the following post for that:
Blob to File
Abdul Aqeel Malik
thanks. this procedure is to convert blob in table to file.
In my case if I get file with file browser and when user press save button I want to change file name to voucher number just saved and save file on disk. I think for this purpose we don't need to save file into blob table and than convert to file. please guide me if I am wrong.