cancel_own_transaction()

relationalai.api

cancel_own_transaction(transaction_id STRING)

A procedure that issues an owner-scoped cancellation request for the specified transaction_id. Once the transaction is canceled, its STATE is reported as CANCELED in the api.transactions view. Requires the all_schema_ro application role.

Parameters

Name	Type	Description
transaction_id	STRING	The ID of the transaction to cancel.

Returns

STRING

Example

Use the api.cancel_own_transaction() procedure to cancel your own transaction:

-- Cancel your transaction with the ID '02c8fa31-1234-5678-90ab-abcdef123456'.
CALL relationalai.api.cancel_own_transaction('02c8fa31-1234-5678-90ab-abcdef123456');
/*+------------------------+
  | Cancelling transaction |
  +------------------------+ */

Transaction IDs can be found in the ID column of the api.transactions view.

It may take a few moments for the transaction to be canceled. Use the api.transactions view or the api.get_transaction() procedure to check the status of the transaction. Once the transaction is canceled, its STATE is reported as CANCELED.

See Compute Resources for more information on managing transactions.

See Also

• api.transactions
• api.get_transaction()
• api.get_transaction_problems()