Oracle Error ORA-01461

The error message presented: “ORA-01461: can bind a LONG value only for insert into a LONG column”, due to the Bind be enabled (recommended), the real error is masked.

If Bind is disabled, the message that appears is: “ORA-01704: string literal too long” which is the correct error message.

 

Check in your source code what is being sent to the Database and your NLS-LANG configuration.

The following two tabs change content below.
Software Architect and Backend Developer (almost Fullstack), I usually work with C#, PowerShell, Python, Golang, bash and Unity (this one is more for a hobby). I'm always looking for something new to learn, adding new tools to my utility belt.
Posted in Dev, PowerBuilder and tagged , , , , , , , , , , .