I just found out that column FILE_NAME in APEX_WORKSPACE_FILES view (Apex 3.0.0) is mostly empty because the it maps to column TITLE of the underlying table WWV_FLOW_FILE_OBJECTS$.
The good news is that in the latest version of Oracle Application Express (3.0.1), this issue seems to have been solved, but unfortunately i could not check the actual source yet, i could only compare the results of similar queries.
Practically speaking, if you need a list of names of files stored in Apex repository and you haven't migrated to Apex 3.0.1, then you are better off using view WWV_FLOW_FILES, which is available through all Apex versions and contains not only the files associated with an application, but also the spare ones.
2 comments:
I really like your blog.. very nice colors & theme.
Did you design this website yourself or did you hire someone to do
it for you? Plz reply as I'm looking to create my
own blog and would like to know where u got this from.
kudos
Ahaha, thank you for the good joke ;-)
It looks awful, when I'll be in a very good mood may be I'll spend a couple of hours searching for a better template.
Have a nice day.
Flavio
Post a Comment