ORA-01459

[axe]

We are seeing this error in production using a third party app, but not seeing it in dev. Both instances are 8.1.7 on Unix.

Anyone seen this and have any suggestions?

[stecal]

Are you asking what the error is about, or are you asking why you are getting it with respect to your application? Forms, or no forms?

Error: ORA 1459 Text: invalid length for variable character string ------------------------------------------------------------------------------- Cause: The buffer length was less than the minimum required (two bytes) or greater than its length at bind time minus two bytes. Action: None. Buffer length is set correctly by Oracle at fetch time.

[axe]

Since there is not much documentation on the error, I am asking whether anyone has ran into it before and if so what was the cause/fix?

[stecal]

Here is more info:

ORA-01459 invalid length for variable character string

Cause: The buffer length was less than the minimum required or greater than its length at bind time minus two bytes.

Action: Make sure the string size is long enough to hold the buffer.

Can you set the buffer to a greater value?