GET_SUPPORTING_OBJECT_SCRIPT Function

This function gets supporting object scripts defined in an application.

Note:

The workspace ID must be set before the call.

Syntax

APEX_UTIL.GET_SUPPORTING_OBJECT_SCRIPT (
    p_application_id  in number,
    p_script_type     in varchar2 ) return clob;

Parameters

Table 35-59 GET_SUPPORTING_OBJECT_SCRIPT Function

Parameter	Description
p_application_id	The application ID to get supporting objects from.
p_script_type	The supporting objects script type. Valid values are apex_util.c_install_script, apex_util.c_upgrade_script, apex_util.c_deinstall_script.

Example

The following example shows how to set workspace ID for workspace FRED, then get supporting objects from application ID 100.

declare
    l_install_script   clob;
    l_upgrade_script   clob;
    l_deinstall_script clob;
begin
    apex_util.set_workspace( p_workspace => 'FRED');

    l_install_script := apex_util.get_supporting_object_script( p_application_id => 100,
 p_script_type => apex_util.c_install_script );
    l_upgrade_script := apex_util.get_supporting_object_script( p_application_id => 100,
 p_script_type => apex_util.c_upgrade_script );
    l_deinstall_script := apex_util.get_supporting_object_script( p_application_id => 100,
 p_script_type => apex_util.c_deinstall_script );
end;