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.
Breno RdV
Please allow me to introduce myself...I'm a former psychologist, with almost a decade worth of experience in Human Resources and People Management. Now a developer/software analyst working with PowerBuilder, C#, PowerShell and currently expanding to the world of Python, Xamarin, PHP Angular and (why not?) Unity.



Posted in Dev, PowerBuilder and tagged , , , , , , , , , , .