I am trying to find the reason of failure of an old session. I am having the session id. As this is Proc there are multiple SQL that was run. So I checked the DBQL and found last ran statement. Ideally this should be the failure statement.
But this does not show the failure reason.
Is there any other way to find the query ran in the Session and the failure reason?