20 thoughts on “Create a login screen in oracle forms builder 10g

  1. kindly elaborate this more.Notice that above code contain global_variable So We need to add Trigger (form_level)/When_new_forms_instance.Inside this trigger add :GLOBAL.COUNT = 0and about the logout code? 🙂

    Like

  2. I'm new to Oracle Forms 10g. When I create a data block based on a table using Data Block Wizard, the block's Query Data Source Columns property is automatically populated with column definition entries corresponding to the columns of the base table.I tried making changes to these entries, for example by changing the data types to wrong data types or even deleting them, and I found that those changes had no effect on the block at all. The form was still working as I wanted. Please explain what is exactly the role of the block's Query Data Source Columns property. Thank you very much.p.s: The F1 key help says “The Query Data Source Columns property is valid only when the Query Data Source Type property is set to Table, Sub-query, or Procedure”. So, please explain in each context of Query Data Source Type.

    Like

  3. i have an error it says”Error 49 line 5 column 19 bad bind variable 'LOGIN.TI_USER_ID'Error 49 line 6 column 19 bad bind variable'LOGIN.TI_PASSWORD'can you help me sir?

    Like

  4. i have an error it says”Error 49 line 5 column 19bad bind variable 'LOGIN.TI_USER_ID'Error 49 line 6 column 19bad bind variable'LOGIN.TI_PASSWORD'panu to ayusin ate?

    Like

  5. declareuname login.username%type;pass login.password%type;cursor mycur is select username,password from login;begin open mycur; loop fetch mycur into uname, pass; if :username=uname and :password= pass then message('valid user'); exit when mycur%found; elsif mycur%notfound then message ('invalid user'); exit when mycur%notfound; end if; end loop; close mycur;end; error login.username must be declared

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.