Hi, all - I've been searching and searching on the internet for an answer to this question, but found nothing. I hope someone here knows the answer.
I need to be able to query the "dictionary" to find out which user query returned a certain error code, say ORA-02291, something along the lines of "select sql_text from v$sql where [the error code was 2291]"
I have set up test tables to force the errors and have found that the offending sql text is present in v$sql, but nowhere can I find where the error code is stored. I've checked DBA_ERRORS, ALL_ERRORS, USER_ERRORS and a host of other tables named '%ERR%' . . . but they're all empty.
Does anyone know where the return value is stored?