DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: ora-06502

  1. #1
    Join Date
    Jan 2001


    Hi all,
    I have a PL/SQL procedure that reads data from a DB2 table across a database link using Oracle Gateway. The column causing me a problem is a CHAR(10) on the DB2 side. I am reading it and placing the data into an Oracle table where this column is defined as VARCHAR2(10).

    If the data in the DB2 CHAR(10) column is like '1880 E', I get the following error when running my proc:

    06502: PL/SQL: numeric or value error: character to number conversion error

    If I remove the 'E', it runs without error. Since this is just a CHAR to VARCHAR2 conversion, why should I get this error? I have tried to fix it by setting the field to TO_CHAR(DB2 field) on the update, but then I get this error:

    PLS-00307: too many declarations of 'TO_CHAR' match this call

    Any ideas?
    BTW, using Oracle


  2. #2
    Join Date
    Jan 2001
    OOOOPS..put this in wrong forum..will repost correctly.

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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.