My Oracle Support Banner

Add List To Target Group Via Event Error ORA-01461 Can Bind a LONG Value Only For Insert Into a LONG Column (Doc ID 1929807.1)

Last updated on JULY 20, 2020

Applies to:

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


Adding a list to a target group via an Event throws an error.

Exception Details.
java.sql.SQLException: ORA-01461: can bind a LONG value only for insert into a LONG column
ORA-06512: at "APPS.FND_SESSION_MANAGEMENT", line 1678
ORA-06512: at line 1


Navigate to Oracle Marketing Super User >Event
Create a new Event. Then click on Event schedule in cue card to create a new Event schedule for this event.
After creating new Event Schedule, click on Campaign link in cue card to create a new campaign for this schedule.
Click on Create Button to create new campaign(Make sure to use very large name for this campaign).
After creating campaign, create a new Activity(Make sure to use very large name for this activity) for this campaign.
Now click on Target group tab for this activity to crate a target group.
Create a new target group(Use very big name for this)
Add a list and receive error


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.