We're migrating a large quantity of CF 4.5 code to MX 7. It seemed like a good idea at the time, but we've hit a major hurdle. We have quite a few Oracle stored procs that have a VARCHAR2 output parameter.
Everytime that parameter has a value we get the following error message: [Macromedia][SequeLink JDBC Driver][ODBC Socket][Oracle][ODBC][Ora]ORA-06502: PL/SQL: numeric or value error: character string buffer too small ORA-06512: at "PFS.AFFILIATEMGMT", line 3421 ORA-06502: PL/SQL: numeric or value error: character string buffer too small ORA-06512: at line 1 We're using the ODBC Socket connection because the JDBC connection wouldn't let us get result sets back from Oracle. Any help with this message would be very appreciated. I can provide sample procedure code if the problem seems to be on the Oracle side. Jennifer Dodson Programmer / Analyst Pioneer Services 4700 Belleview Suite 300 Kansas City, MO 64112 Phone 816-448-2391 Fax 816-756-0942 [EMAIL PROTECTED] ---------------- PIONEER SERVICES is a brand name and registered service mark of Pioneer Licensing Services, Inc., where its use is duly licensed to affiliates and partners of Pioneer Licensing Services, Inc. Confidentiality Notice: The information contained in this e-mail transmission, including any attachments, is confidential information, proprietary to the sender and legally protected. Its purpose is intended for the sole use of the individual(s) or entity named in the message header. If you are not the intended recipient, you are hereby notified that any dissemination, copying or taking any action in reliance on the contents of this information is strictly prohibited. If you received this message in error, please notify the sender of the error and delete this message and any attachments. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:242595 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
