Results 1 to 2 of 2

Thread: err ora-01406

  1. #1
    Join Date
    Oct 2002
    Posts
    36

    Unanswered: err ora-01406

    ORA-01406: fetched column value was truncated
    Cause: In a host language program, a FETCH operation was forced to truncate a character string. The program buffer area for this column was not large enough to contain the entire string. The cursor return code from the fetch was +3.

    Action: Increase the column buffer area to hold the largest column value or perform other appropriate processing.


    iam getting the above in toad but iam unable to rectify it.
    how to increase the column buffer area what option we have to chk for that

    thank u

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1

    Re: err ora-01406

    What were you doing in Toad when you got the error? If you were running your own PL/SQL code then the problem may be in your code. If you were performing DML, the problem could be in a trigger. Otherwise, the problem may be a Toad bug.

Posting Permissions

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