The behavior of DDL requests specified within the body of SQL procedures at runtime depends on the session mode in place when the procedure is created.
- A DDL request specified within an explicit transaction in a procedure in Teradata session mode must be the last request specified in that transaction. Otherwise, the system raises a runtime exception.
- When you perform a procedure in ANSI session mode, each DDL request specified in the procedure body must be explicitly terminated by a COMMIT WORK request. Otherwise, the system raises a runtime exception.