43.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 43-59 GET_SUPPORTING_OBJECT_SCRIPT Function
Parameter | Description |
---|---|
|
The application ID to get supporting objects from. |
|
The supporting objects script type. Valid values are |
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;
Parent topic: APEX_UTIL