When a stored procedure (SP) call is made through Unity with CDM enabled, Unity uses enhanced SP handling for that SP call. With enhanced SP handling, the database engine forwards each statement from the SP body to Unity, and Unity SQL replicates or CDM replicates each statement.
Each individual statement from the SP body is sent to Unity for replication purpose, lifting all traditional Unity SP limitations. This allows Unity to support SP containing dynamic SQL, conditional execution patch, multiple DDL, multiple transaction, and so on.