DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2005

    ORA-01485: compile bind length different from execute bind length - How to fix???

    Dear All
    I use Array bunding - with very huge array ang get the folowing Error
    "ORA-01485: compile bind length different from execute bind length"
    by inspecting this error i have descovered that i need to rnlarge a buffer that is smaller the existing buffer which is being used while execution. how should i change this buffer size????

    "You bound a buffer of type DTYVCS (VARCHAR with the two byte length in front) and at execute time the length in the first two bytes is more than the maximum buffer length, given in the bind call. ....."

    "Action: Ensure that the buffer size is sufficiently large to contain the array plus two bytes for the buffer length. "

    How should i consider this Action????
    Thnks alot

  2. #2
    Join Date
    May 2000
    Can you post the code?


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.