ORA-01406 : fetched column value truncated
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: ORA-01406 : fetched column value truncated

  1. #1
    Join Date
    Aug 2005
    Posts
    3

    ORA-01406 : fetched column value truncated

    Hi,

    i am getting this error:


    ORA-01406 : fetched column value truncated

    ther are around 50,000 rows . None of the rows exceed the length of the datatype.

    any help much appreciated

  2. #2
    Join Date
    Mar 2004
    Posts
    8
    The Oracle Doc explain:
    ORA-01405 fetched column value is NULL
    Cause: The INTO clause of a FETCH operation contained a NULL value, and
    no indicator was used. The column buffer in the program remained unchanged,
    and the cursor return code was +2. This is an error unless you are running
    Oracle with DBMS=6, emulating version 6, in which case it is only a warning.
    Action: You may do any of the following:
    1. Use the NVL function to convert the retrieved NULL to another value, such
    as zero or blank. This is the simplest solution.
    2. Use an indicator to record the presence of the NULL. You probably should
    use this option when you want a specific action to be taken when a NULL
    arises.
    3. Revise the cursor definition so that no columns possibly containing NULL
    values are retrieved.

    You can cousult these words to debug.

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