Forum Stats

  • 3,837,010 Users
  • 2,262,219 Discussions
  • 7,900,182 Comments

Discussions

deleting application items via PL/SQL

Christian1985
Christian1985 Member Posts: 6 Red Ribbon
edited Mar 10, 2022 9:20AM in APEX Discussions

Hello pros,

I have noticed that there are some unused Application Items in my application. Deleting them one by one through the backend is kind of costly. Is there an integrated procedure to delete single application items with a PL/SQL statement?

Then I could clean up the items in regular intervals.


Simply deleting them from the WWV_FLOW_ITEMS table seems a bit too risky to me, since not all consequences can be estimated.


Many greetings

Christian

Tagged:

Best Answer

  • jariola
    jariola Member Posts: 10,822 Gold Crown
    edited Mar 10, 2022 10:12AM Answer ✓

    Sounds very strange that you need delete regulary application items. How those are created in first place?

    There isn't supported API to create or delete application items.

Answers

  • jariola
    jariola Member Posts: 10,822 Gold Crown
    edited Mar 10, 2022 10:12AM Answer ✓

    Sounds very strange that you need delete regulary application items. How those are created in first place?

    There isn't supported API to create or delete application items.