I have an Oracle stored procedure being called by through <cfstoredproc>. I can run the stored procedure from "other" client side apps. When I run the procedure in CF, and pass CF_SQL_VARCHAR parameters with a size GT 23, the CF 5.0 Server "hangs". If I pass params LTE 23 the procedure runs fine.
Is there a problem with CF Server 5.0 and <cfprocparam cfsqltype="CF_SQL_VARCHAR">'s with a size GT 23? (As I wrote above, the procedure runs flawlessly in other apps. I've trouble shooted the problem by manually executing the procedure in Oracle with param sizes GT 23 and the procedure runs. I've narrowed the procedure down to the CF Server 5.0.).
Is there a problem with CF Server 5.0 and <cfprocparam cfsqltype="CF_SQL_VARCHAR">'s with a size GT 23? (As I wrote above, the procedure runs flawlessly in other apps. I've trouble shooted the problem by manually executing the procedure in Oracle with param sizes GT 23 and the procedure runs. I've narrowed the procedure down to the CF Server 5.0.).