is there any way to log all failed sql statements in oracle 10g -

Is there any way to log unsuccessful SQL statements in Oracle 10G in any table or file?

By failing, I mean that the poorly formatted SQL statement or SQL statements do not have permission for tables or objects.

You may wish to use auditing:

Audit Selection Table, INSERT TABLE, DELETE TABLE, the process of not reaching successfully;

For each statement by access (which seems like what you want) The session will record a record per session (high volume of environment) in the session.

Created in auditing of Oracle, then there is a trigger. A trigger, which includes other answers, allows you to log in the exact information you want, auditing will only hit the hits on existing objects. If a non-existent table (misspellings or whatnot) chooses on auditing, then it will not catch the triggers above.

More information in the Security Guide: