Currently one of the customers I am working with, use DBMS_LOB.getlength function in a custom field to get the size of a document directly from Edm File Storage.
In case we move documents from database to a FTP , will it be possible to fetch the file size? Is there any method we can fetch the size from a FTP/Shared folder?
Hi,
It is possible, but I'm not sure I would recommend it. We have a method for it but, as you might expect, it needs to get "outside" the database, communicating with the FTP server. We do this via our middle tier code in Java, and we call that Java code via the PL/SQL access provider.
Having that being called as the user populate data is asking for performance problems. If I am right and they get problems, we would not accept that as a bug.
The warning aside, this is the method:
Edm_File_API.Get_Repository_File_Size
Why are they doing this in the first place? What is this information telling the user?
Thanks!
/Mathias
Thank you Mathias for the answer.
Customer use this custom field to see whether the physical file is connected to ORIGINAL or VIEW record in EDM_FILE_STORAGE.
/Nicum
Thank you Mathias for the answer.
Customer use this custom field to see whether the physical file is connected to ORIGINAL or VIEW record in EDM_FILE_STORAGE.
Do they use the size to determine if it is an original file or a view copy? Why not look at the file type?
Thank you Mathias for the answer.
Customer use this custom field to see whether the physical file is connected to ORIGINAL or VIEW record in EDM_FILE_STORAGE.
Do they use the size to determine if it is an original file or a view copy? Why not look at the file type?
I do believe majority of customers in Norway have this set in base profile. Both nice to see the size of file before you download (largest we have is 5,5 GB), as well as seeing there actually is a file there and not only an “empty” record. For documents with Original files you can also see if a View file exist.
Thanks for the input, @BjornH !
Hi @Mathias Dahl
I have the same question as @nicwlk. Almost sure I’ve seen somewhere that it is possible, but not recommended for performance issues, though may mix up with something else.
We have currently moved majority of documents out from DB to local shares on application server, that way we are 100% sure there are never mix up between Prod and Test environment. There are some API’s not working well with “share”, but nothing we haven’t been able to work our way around, except the file-size that is needed on occasions.
Cheers, Bjørn
Hi @Mathias Dahl
I have the same question as @nicwlk. Almost sure I’ve seen somewhere that it is possible, but not recommended for performance issues, though may mix up with something else.
If you mean check the file size, yes it is discussed above, and I also mention a possible performance impact there.
We have currently moved majority of documents out from DB to local shares on application server, that way we are 100% sure there are never mix up between Prod and Test environment. There are some API’s not working well with “share”, but nothing we haven’t been able to work our way around, except the file-size that is needed on occasions.
Good to know, thanks!
