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.
