Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

This operation will select all available endpoints associated to the environment/instance.

 


Endpoint Execution

This operation will execute on any one of the selected endpoints and will be random in the determination of which one.

...

For renames, the old_owner must be the same as the new_owner.


For user defined type objects, special consideration should be given to implementing the force option on the type.  In a scenario where a type is dependent on another type, there are scenarios where creating the child type with the force will make the deployment to future environments easier.

Example:

In this case, the type XX_WS_INPUT_T is a child of the type XX_WS_INPUT_TBL.  By creating it with the force in the build database, the plugin will automatically carry that option forward:

create or replace TYPE XX_WS_INPUT_T FORCE AS OBJECT (
TABLE_NAME VARCHAR2( 30 )
,COLUMN_NAME VARCHAR2( 30 )
,IN_VALUE VARCHAR2( 250 )
);

create or replace TYPE XX_WS_INPUT_TBL AS TABLE OF XX_WS_INPUT_T;


Future changes to the XX_WS_INPUT_T type (like adding a column) will then flow through the plugin without issue because it will be recreated using the force option.  Without the force option, the plugin would fail with the error message:

ORA-02303: cannot drop or replace a type with type or table dependents


Please note, the use of the force option will cause the parent type and any dependent type will be invalid and will require a recompile.  This can complete in FlexDeploy by using the compile_invalid plugin operation in the workflow.