ORA-01459
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: ORA-01459

  1. #1
    Join Date
    Sep 2002
    Posts
    17

    Exclamation

    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?

  2. #2
    Join Date
    May 2002
    Posts
    2,645
    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.

  3. #3
    Join Date
    Sep 2002
    Posts
    17
    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?

  4. #4
    Join Date
    May 2002
    Posts
    2,645
    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?


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width