Post stops with "Unexpected Oracle error: ORA-01461: can bind a LONG value only for insert into a (4299286)

Post stops with the following message in the event_log:

9/08/08 22:55 Error: Unexpected Oracle error: ORA-01461: can bind a LONG value only for insert into a LONG column. (object name: "SCHEMA"."TABLE") [sp_opst (for o.SID-o.SID queue queuename)/5187]
09/08/08 22:55 Notice: ORA-01461: can bind a LONG value only for insert into a LONG column. [sp_opst(osp)/5187]

This is an error message caused by an Oracle bug in Oracle Version 10.2.0.3. Refer to Oracle Metalink document 456462.1 (Bug #5887228). Here the link to the document:

https://metalink.oracle.com/metalink/plsql/f?p=130:14:5497351435078033734::::p14_database_id,p14_docid,p14_show_header,p14_show_help,
p14_black_frame,p14_font:NOT,456462.1,1,1,1,helvetica

Resolution:
Refer to the Oracle document #456462.1 for details

Workaround 1:
Upgrade to SharePlex version 5.3.4.60 and up. This, and subsequent, versions include Patch ST40775 which  provides an automatic restart of post.

Workaround 2:
Add the error message 1461 to the oramsglist, this way post won't stop anymore after encountering this error. See the Reference Guide SP_OPO_CONT_ON_ERR parameter and/or SOL277 on how to implement.

Workaround 3:
Restart post manually.