Is it possible to have a Custom Menu of type 'PL/SQL Block' perform its action (like inserting a new row) and then also switch the client to a different window, all from within that same PL/SQL Block menu item, rather than needing two separate custom menus run manually one after another?

All FAQ questions / Developer Studio, deployment, and upgrades

Answer

No — it isn't possible to switch to a different window directly from within a PL/SQL Block-type Custom Menu's own executed code; that specific action type can only run PL/SQL logic, not perform a client-side window navigation. The practical, if not maximally user-friendly, solution is to keep two separate Custom Menu items: one of type PL/SQL Block for the actual logic/data change, and a second of type Create-Window-With-Transfer for the actual window navigation, executed manually one after the other by the user, since there's no way to combine both actions into a single PL/SQL-Block-type Custom Menu.

Documentation-based answer. Confirm the product and release before applying it. This answer has not been verified in an IFS environment.

← Browse Developer Studio, deployment, and upgrades questions