7 Replies Latest reply on Jan 10, 2010 9:25 AM by DUOS

    ORA-20001: Error fetching column value: ORA-06502: PL/SQL: numeric or value

    DUOS
      I have an application made in devlopment which is working fine and i jsut migrated it to production but when i am running one of the page in the app in production it si throwing this error "ORA-20001: Error fetching column value: ORA-06502: PL/SQL: numeric or value error: character string buffer too small"... this report is ment for generating report.

      Now what i have done, i compared both dev and prod environment but i have not found and changes except this one. In the page of both the application in dev and prod under shared component under under template the region of breadcrum and report region is showing in different position. i dont think it a problem because of that i am facing problem.

      If anybody have idea how could i recitfy the prbs i will be highly thankful to you

      Regards
      Adi