Execute-immediate

In the execute-immediate method, the client application sends the server a ct_dynamic command that executes a literal statement.

Execute-immediate is usually used for one-time execution, and does not involve fetchable data. Also, it does not use a unique identifier. Therefore, if a failover were to occur in the middle of its execution, the entire transaction is rolled back, and a 1205 deadlock message is sent to the client application.