Logging failed SQL statements using system view

[[email protected]]

hi,

we would like to enhance our error-logging by logging failed sql statements.
in other words, when a user does something in our system which causes a sql error,
we would like to log the corresponding sql statement.

in order to do this, we need a way to fetch this statement by using a sql query.
is there maybe something like a system view with failed sql statement where
i can just fetch the latest one?

would be very glad for some advice.

[dimitri]

Hi,

das ist ein deutsches Forum, daher die Antwort auch in deutsch.
Fehlerhaft geparste SQLs werden nicht im Shared Pool abgelegt, daher gibt es auch keine Möglichkeit sie irgendwie zu rekonstruieren.

Dim