Learn the purpose and how to get to the bottom of the ORA-01013 error message in Oracle.
Description
When you encounter an ORA-01013 error, the following error message will appear:
ORA-01013: person requested cancel of current operation
Cause
You interrupted an Oracle operation by way of pressing Ctrl+C or by canceling the operation thru any other method (ie: front-end application).
Resolution
The option(s) to resolve this Oracle error are:
Option #1
The current operation has been terminated through the user. There is no path of motion to take. This message is informational only.
Option #2
This error might also also have been prompted via a timeout in a sql pass-through query. To get to the bottom of this error, homes of the timeout parameter need to be changed to a greater value.