On successful completion of the procedure object, a success response is returned to the client application.
The following statements need to be specified to complete the procedure creation, depending on the session mode.
| Session Mode | Statements Required |
|---|---|
| ANSI | An explicit COMMIT statement. |
| Teradata | An explicit END TRANSACTION statement if the transaction is explicit. No such statement is required if the transaction is implicit. |