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

Popular posts from this blog

monitor web browser programmatically in Android? -

Shrink a YouTube video to responsive width -

wpf - PdfWriter.GetInstance throws System.NullReferenceException -