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. Use this procedure for logic reasoners. Predictive and prescriptive reasoners use the job APIs instead. 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()