28.68 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 28-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;