E-AE: Application Engine PeopleCode Step with SQLExec Receives Error; return code 8015 "Bind value is too long" (Doc ID 889806.1)

Symptoms

Application Engine (AE) program with PeopleCode Step that does SQLExec function which includes INSERT INTO table with a long field. When the Long field data is greater than 254 characters, the AE fails with return code 8015 "Bind value is too long"


ERROR
---------------
In Oracle Database;

The issue can be reproduced with the following steps:

1. Use Application Engine program with PeopleCode step that does SQLExec INSERT INTO table with Long field.
2. Data to insert into long field has length greater than 254 characters.
3. Run Application Engine program.
4. Observe resulting Return of 8015 - Bind value is too long

Cause

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