ORA-01461: Can Bind A LONG Value Only For Insert Into A LONG Column When Submitting A Cover Letter

(Doc ID 1684297.1)

Last updated on SEPTEMBER 24, 2017

Applies to:

Oracle Marketing - Version 12.1.3 and later
Information in this document applies to any platform.
Reviewed April 2016

Symptoms

When submitting a cover letter, the following error is encountered:

oracle.apps.fnd.framework.OAException: java.sql.SQLException: ORA-01461: can bind a LONG value only for insert into a LONG column
ORA-06512: at "APPS.FND_SESSION_MANAGEMENT"
AMS error ORA-01461: can bind a LONG value only for insert into a LONG column


The issue can be reproduced at will with the following steps:

1. Log into application Marketing Online > Event
2. Select a short-cut to the Event schedule
3. Select an Event schedule’s name
4. Click on campaign on the left panel
5. Click on create
6. Fill in the field to create the campaign
7. Click on Apply
8. Click on Create Activity
9. Fill in the fields
10. Click on collateral tab
11. Select the coverletter type and click on create
12. Fill in the fields
13. Click on Apply
14. Error is encountered


Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms