Posts

Showing posts from September, 2015

How to delete concurrent Program from back end

This is article will help to delete Concurrent Program and Executable ------------------------------------------------------------------------------- -- delete concurrent program definition and executable from back-end ------------------------------------------------------------------------------- -- syntax: --     delete_program    (program_short_name, application_short_name) --     delete_executable (program_short_name, application_short_name) ------------------------------------------------------------------------------- DECLARE   lv_prog_short_name    VARCHAR2(240);   lv_appl_short_name    VARCHAR2(240); BEGIN    -- set the variables first    lv_prog_short_name := 'XWSHRLODKRA';     -- concurrent program short name    lv_appl_short_name := 'WSH';          -- application short name    -- see if the program exists. if found, delete ...