一应用程序报错: ORA-24337
/home/oracle$ oerr ora 24337
24337, 00000, " statement handle not prepared"
// *Cause: A statement cannot be executed before making preparing a request.
// *Action: Prepare a statement before attempting to execute it.
检查应用运行日志,cp出运行的SQL语句, 格式化后发现SQL语句这次没有正确结束,无法执行。与开发沟通后发现,SQL语句的变量定义长度为256,正常情况下都可以控制在256内,而本次的SQL长度超出256,故报错ORA-24337. 解决办法是将变量长度延长到500,运行正常。