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

Thread: ora-01460

  1. #1
    Join Date
    Oct 2003


    Hi all,

    I just convert my database to UTF8, today when I tried to open a trigger in the database from SQL Navigators, I got the error:"

    ORA-01460: unimplemented or unreasonable conversion required

    I research in Metalink and it said:

    Any bind variable (not specific to CLOB) to a PLSQL program unit exceeding 32K will run into this problem.

    what do they mean by this??? and how to fix this problem???

  2. #2
    Join Date
    Jun 2001
    Helsinki. Finland

    Re: ora-01460

    Run regedit and change NLS_LANG to AMERICAN_AMERICA.UTF8
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g,12c
    email: ocp_9i@yahoo.com

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.