the problems are hard to explain.
A few weeks ago I changed a PL/SQL-Process in a application. But if I ran the page I couldnt see my changes. The process runs as before. Then I changed the proces again and put some "insert into test"-statements in the process to ensure that the changes are executing. But still the process works without any changes. Then I export the application, drop it and import it again. After that the process was running fine.
Later I dropped a item, but after dropping I could still see the item in the Application Builder. Then I tried to edit the item, but I got the message "No data found". I checked all items with
and I saw that the item was dropped of course, but the Application Builder still showed it. Closing the browser, clearing the browser cache didnt help. Then I export the application, dropped it again and import it. After that the item was not in the Applictation Builder.
Today I run the application and I get the failure
Error during rendering of region "Vorbereitete Prüfungen".
ORA-22922: nonexistent LOB value
ora_sqlerrm: ORA-22922: nonexistent LOB value
component.name: Vorbereitete Prüfungen
ORA-06512: in "APEX_040200.WWV_FLOW_DISP_PAGE_PLUGS", Zeile 4613
ORA-06512: in "APEX_040200.WWV_FLOW_DISP_PAGE_PLUGS", Zeile 3220
After this failure I export the application and import it in a other application-id. The "new" application is now running fine (at least in this moment!).
What is my problem?
We are using APEX 4.2.2.00.11.
you wrote "Then I export the application, drop it and import it again". Does this mean that you removed the item from the export file? Maybe some inconsistency with this item occurred because of a former edit operation. This is very easy to get wrong, especially if you are merging changes of different versions. It would explain why you sometimes see the item, but can not delete it and get runtime errors.
no, I didtn have to remove the item from the export-file, because in the export-file the item was not present.
It look as the items are cached. In the database the dropped item was not present, also not in the export-file. Only the page-view in the Application Builder showed it. After that I used another browser, but also there I saw the item in the application builder.
Are there more as one place where APEX stores the items? Is there a temporary place that is maybe not consistent with the application?
there is no such temporary place. If you are really curious, you can have a look at the internal repository tables. Just do not expect that their structure stays the same between versions and never run any insert/update/delete on them, unless Oracle Support tells you to. You would probably be interested in wwv_flow_page_plugs (regions) and wwv_flow_step_items (page items, referencing regions via item_plug_id).