My Oracle Support Banner

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 JULY 17, 2020

Applies to:

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


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
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


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

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