Oracle"SQL错误:在索引:1处缺少IN或OUT参数" [英] Oracle "SQL Error: Missing IN or OUT parameter at index:: 1"

问题描述

我有一个类似于以下内容的Oracle脚本:

I have an Oracle script that looks like the following:

variable L_kSite number;
variable L_kPage number;
exec SomeStoredProcedureThatReturnsASite( :L_kSite );
exec SomeStoredProcedureThatAddsAPageToTheSite( :L_kSite, :L_kPage );
update SiteToPageLinkingTable 
set HomePage = 1 
where kSite = :L_kSite and kPage = :L_kPage;

应该说最后一条语句是对绑定变量的有效使用，但是当我尝试运行脚本时，我在最后一行得到了这一点:

Supposedly the last statement is a valid use of a bind variable but when I try to run the script I get this on the last line:

SQL Error: Missing IN or OUT parameter at index:: 1

由于我不太精通Oracle，因此我不确定如何进行此操作.

I'm not sure how to proceed here as I'm not especially proficient in Oracle.

推荐答案

基于上面的注释，我在sqlplus而不是SQL Developer下运行了该程序，并且UPDATE语句运行得很完美，使我相信这是SQL Developer中的问题尤其是因为没有返回ORA错误编号.谢谢您带领我朝正确的方向前进.

Based on the comments left above I ran this under sqlplus instead of SQL Developer and the UPDATE statement ran perfectly, leaving me to believe this is an issue in SQL Developer particularly as there was no ORA error number being returned. Thank you for leading me in the right direction.

这篇关于Oracle"SQL错误:在索引:1处缺少IN或OUT参数"的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！