Tuesday, July 31, 2007

Apex sVista #2

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.

No comments:

yes you can!

Two great ways to help us out with a minimal effort. Click on the Google Plus +1 button above or...
We appreciate your support!

latest articles