Consider the scenario when a procedure references another procedure that has been dropped or renamed.
If the called procedure X references another procedure Y, and Y is later dropped, renamed, or replaced before executing X, the following occurs:
|Session Mode||Condition Generated when X Submits an Internal CALL to Execute Y|
If Y is replaced, then its execution generates an error in ANSI session mode or a failure in Teradata session mode if the specified arguments are not compatible with the changed definition of Y.
- The number of call arguments is not equal to the number of parameters in the changed definition of Y.
- The data type of the call arguments is incompatible with the changed parameters of Y.
These conditions also apply to the attributes of any referenced database objects.