cancel_transaction()

relationalai.api

cancel_transaction(id STRING)

A procedure that issues a cancellation request for the specified id. Requires the all_schema_ro application role.

Parameters

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

Returns

STRING

Example

Use the api.cancel_transaction() procedure to cancel a transaction:

-- Cancel the transaction with the ID '02c8fa31-1234-5678-90ab-abcdef123456'.
CALL relationalai.api.cancel_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 Manage reasoner jobs for more information on managing transactions.