|
What are ORA-700 errors?
ORA-700 errors are referred to as soft asserts in 11g. Basically these are internal errors that do not cause anything fatal to occur in the process, and so the process can continue. Soft asserts are triggered when the caller wants to make a note of the fact that something unexpected has happened, but would like to continue on because the failure is not fatal to the process or the instance. In such cases, the process just records the error, takes the corresponding dumps and moves on as though nothing happened.
Are ORA-700 errors similar to ORA-600 in 10g?
Yes, ORA-700 errors separate less harmful ORA-600 errors from the ones that cause huge impact like instance failures. For example, if the code finds that a hint in a query is corrupt, it can just raise a soft-assert since the query can be run without the hint being used, and so doesn't need to crash the process. So in 11g, for such a condition an ORA-700 error would be raised.
General Format of ORA-700 error is:
ORA-00700: soft internal error, arguments: [%s], [%s], [%s], [%s], [%s], [%s], [%s], [%s] |
Example:
ORA-700: soft internal error, arguments: [kgeade_is_0], [], [], [], [], [], [], [] |
|