Add List To Target Group Via Event Error ORA-01461 Can Bind a LONG Value Only For Insert Into a LONG Column
Last updated on SEPTEMBER 06, 2016
Applies to:Oracle Marketing - Version 12.1.3 and later
Information in this document applies to any platform.
Reviewed 21st Aug 16
Adding a list to a target group via an Event throws an error.
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
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