没有语句解析和错误的数字或类型的参数 - cfstoredproc [英] no statement parsed and wrong number or types of arguments - cfstoredproc

问题描述

我有一个Oracle过程 - editBacklog，我通过cfstoredproc从CFM页面调用。在对过程进行了多次更改后，我开始获取 ORA-06550：第1行，第7列：PLS-00306：调用'EDITBACKLOG'时出现错误的数字或类型的参数。我已经得到这个前，发现，如果我改变了程序的名称，它开始工作了。我改名为editBacklog2，它的工作，我预期它。我把名称改回editBacklog，并得到相同的错误。我将名称重新更改为editBacklog2，并开始获取 ORA-01003：无语句分析。 NOTHING在这一点上已经改变，除了名字。我再次改名为editBacklog3，它的工作原理如预期。

截至目前为止

editBacklog = ORA-06550

editBacklog2 = ORA-01003

editBacklog3 = works（kinda）

这一切开始于我试图修复ORA-01821：日期格式无法识别错误。我恐怕当我开始改变的东西，我会开始得到与上述相同的跛脚行为。

Oracle或CF正在搅乱我，我最终会喜欢一个

我认为它可能是cfstoredproc缓存元数据或东西，但google，livedocs或OTN对我的情况都不多说。

我不是SA或DBA。

任何人都有什么想法？

两个建议：

在ColdFusion管理员中禁用/重新启用数据库连接（数据源，显示高级设置，禁用连接复选框）

进入您的数据库的任何管理模块并从ColdFusion中删除会话

无论哪种方式，重新建立连接将导致存储的Proc重新缓存。

I have an Oracle procedure - editBacklog which I'm calling from a CFM page via cfstoredproc. After several changes to the procedure I started getting ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments in call to 'EDITBACKLOG'. I've gotten this before and found that if I changed the name of the procedure it starts working again. I changed the name to editBacklog2 and it worked as I expected it to. I changed the name back to editBacklog and got the same error. I changed the name back to editBacklog2 again and started getting ORA-01003: no statement parsed. NOTHING has changed at this point except for the names. I changed the name yet again to editBacklog3 and it works as expected.

As of right now
editBacklog = ORA-06550
editBacklog2 = ORA-01003
editBacklog3 = works (kinda)

This whole thing started when I was trying to fix an ORA-01821: date format not recognized error. I fear when I start changing things I'll start getting the same lame behavior described above.

Either Oracle or CF is messing with me and I'll end up liking one of them less because of it.

I assume it's probably cfstoredproc caching metadata or something but neither google, livedocs, or OTN have much to say about my situation.

I'm not the SA or DBA.

Anyone have any ideas?

解决方案

ColdFusion caches some stuff when dealing with the database.

Two suggestions:

1. Disable/re-enable the database connection in the ColdFusion Administrator (Data Source, Show Advanced Settings, Disable Connections checkbox)

2. Go into whatever administration module you have for your database and kill the sessions from ColdFusion

Either way, re-establishing the connection will cause the Stored Proc to be re-cached.

这篇关于没有语句解析和错误的数字或类型的参数 - cfstoredproc的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！