ORA-06502: PL/SQL: numeric or value error: host bind array too small
With 10gR2 dbms_output has been improved to handle more that 255 characters. I ran into this problem when I forgot to consider that it is the CLIENT ( not necessiarily the db server) that must be 10gR2. The PL/SQL procedure would run fine for me because I happened to have the 10gR2 client installed on my PC. Our QA had an older version of the client and kept running into this ora-06502.
So, it's probably not a good idea to drop those string chunking procedures until you are sure that everybody is off of the older clients.
Friday, October 12, 2007
ORA-06502: PL/SQL: numeric or value error: host bind array too small
Subscribe to:
Post Comments (Atom)
2 comments:
Hi Mike, thanks for this post. I would never have found out that the client is at fault if not for your post. -- Vincent
Thanks Mike very much. Your notes are clear and useful to me. - Thomas.
Post a Comment