Not all variables bound

See more:

Oracle

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;

====
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