Post dies and event log has the following entry
Notice 2011-06-23 16:07:53.694573 5559 4 s:4 Poster: ORA-01008: not all variables bound. (posting from xxxx, queue yyy, to xxxx) [module osp]
Error 2011-06-23 16:07:53.695914 5559 4 s:4 Poster: Unexpected Oracle error: ORA-01008: not all variables bound. (object name: "aaa"."sss") (posting from xxxx, queue yyy, to xxxx) [module opo]
The variables could not get properly bound due to batch posted as singleton when batch operations failed. Post saves these failed SQL into sql cache.
Add the oracle error to the oramsglist file and have post ignore the oracle error.
To set post to ignore this error use the following procedure.