Tag: Application files

SQL Developer and BLOBs SQL Developer is a very complementary tool to Apex.Although, you can do all basic SQL stuff via the SQL Workshop in Application Express, sometimes you need a more powerful tool like SQL Developer, especially when you really need to ‘develop’ in SQL and PL/SQL. One of the SQL features I like […]

Apex: Housekeeping Your Flow Files In my previous blog, I explained the problem we encountered with flows_files.wwv_flow_file_objects$ aka APEX_APPLICATION_FILES. I did some further investigations on the content of that table to 1) detect the ‘big size spenders’ and to 2) see whether or not there exist some orphan entries. I also wanted to know if […]

Apex: flows_files.wwv_flow_file_objects$ aka APEX_APPLICATION_FILES End of last year, we had a strange problem in our test environment while testing an internal application for maintaining our library of IT-related books. When adding a new book title, we got from time to time a “page not found error” with a reference to wwv_flow.accept in the URL. Strangely […]