My Oracle Support Banner

Bulkplan Errors with java.sql.Exception:ORA-01461: Can Bind a Long Value Only (Doc ID 970374.1)

Last updated on SEPTEMBER 08, 2016

Applies to:

Oracle Transportation Operational Planning - Version: 5.5.05 and later   [Release: 5.5 and later ]
Information in this document applies to any platform.
***Checked for relevance on 06-May-2011***

Symptoms


===================
-- Problem Statement:
On 5.5.05.06, When attempting to run scheduled bulk plans, the bulk plans fail with the the following error

ERROR
-----------------------
BULKPLAN ERRORS java.sql.SQLException: ORA-01461: can bind a LONG value only

-- Steps To Reproduce:
The issue can be reproduced at will with the following steps:
1. Schedule bulk plans to run at certain times of the day
2. Review the logs and see that the bulk plan fails to run due to a Sql Exception

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
  Symptoms
  Cause
  Solution
  References

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.