并非所有变量都受约束 [英] Not all variables bound

问题描述

亲爱的朋友，

我已经创建了用于显示用户详细信息的应用程序流程(Pl Sql函数返回布尔值)，

查询是:

声明

Dear Friends,

I have created Application Process(Pl Sql function Returning Boolean) for Displaying the User details,

Query is:

declare

l_count number;
begin
select count(*) into l_count from usermaster where usertypeid in 
( select usertypeid from usermaster where usertypeid !=1 and userid=:P9_USERID or userid=:new);
 if l_count > 0 then
 return true;
 else
htp.p('<script language="javascript">');
htp.p('alert("Sorry! You dont have Permission to view other information")');
htp.p('window.location ="http://localhost:8080/apex/f?p=112:8:&SESSION.::NO::"');
htp.p('</script>');
 return false;
 end if;
 end;

====
当我在Pl Sql代码内部使用:new关键字时，它显示如下错误:

ORA-01008:并非所有变量都已绑定
错误ERR-1082执行授权方案代码时出错.

请大家告诉我如何编写正确的代码..

问候，
Udayakumar.P

====
when i am using :new keyword using inside the Pl Sql code it Showing the Error like this:

ORA-01008: not all variables bound
Error ERR-1082 Error in executing authorization scheme code.

Pls, Anyone tell me how to write correct code..

regards,
Udayakumar.P

推荐答案

:new代表一行，因此您必须声明哪一列.例如

:new represents a row so you have to state which column. E.g.

...
or userid=:new.userid
...

这篇关于并非所有变量都受约束的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！