oracleforms - Bad bind variable error in Oracle 10g developer form -
i have created table named password
create table password (user_id number(10) constraint password_user_id_pk primary key, passwd varchar2(20) not null); insert passwd (user_id,passwd) values (1,100); insert passwd (user_id,passwd) values (2,200);
and created login form in oracle form developer 10g. , used code login button.
declare cursor login_cursor select user_id, passwd password; user_id_var password.user_id%type; passwd_var password.passwd%type; login_flag boolean := false; begin open login_cursor; <<check_records>> loop fetch login_cursor user_id_var, passwd_var; if( :login_user_id = user_id_var , :login_passwd = passwd_var ) message('you in'); login_flag := true; exit check_records; end if; exit when login_cursor%notfound; end loop; close login_cursor; if( not login_flag ) message('invalid login'); end if; clear_form; end;
but error message appeared
bad bind variable 'login_user_id' bad bind variable 'login_passwd'
what's solution this?
form variables referenced using :block_name.item_name
. you're using :login_user_id
seems missing reference block, hence forms not able reference variable , seems thing it's bind variable, it's not.
correct syntax referencing variables
Comments
Post a Comment