Results 1 to 13 of 13
  1. #1
    Join Date
    Apr 2010
    Posts
    30

    Oracle forms Login Screen

    I want to create an application in oracle forms,whose first page is a login page,with validations for username and password.On entering the correct details that match with the ones in the oracle DB,on click of logon I should be able to navigate to the next page.I need a code for this.The details of the database are table name:login_details,columns ->loginid,Password.

    Thanks in advance

  2. #2
    Join Date
    Nov 2010
    Posts
    3

    Smile

    Quote Originally Posted by narayanyr View Post
    I want to create an application in oracle forms,whose first page is a login page,with validations for username and password.On entering the correct details that match with the ones in the oracle DB,on click of logon I should be able to navigate to the next page.I need a code for this.The details of the database are table name:login_details,columns ->loginid,Password.

    Thanks in advance
    you can have two canvas in a form, one for logon and when logon success go another.
    The trigger when-button-pressed of logon button may like this:
    **************************
    DECLARE
    v_exist VARCHAR2(1)
    BEGIN
    SELECT 'x'
    INTO v_exist
    FROM login_details
    WHERE loginid = :loginid
    AND Password = :Password;

    GO_ITEM('new_block.new_item');

    EXCEPTION
    WHEN NO_DATA_FOUND THEN
    MESSAGE('loginid or password error');
    clear_form;
    END;
    ******************************

  3. #3
    Join Date
    Apr 2010
    Posts
    30
    Hi Yang,

    Thanks for your reply.I am attaching an image.I am getting an error while compiling the code.Quick reply would be appreciated.

    Thanks,
    Narayana
    Attached Thumbnails Attached Thumbnails error.jpg  

  4. #4
    Join Date
    Nov 2010
    Posts
    3

    Red face

    Quote Originally Posted by narayanyr View Post
    Hi Yang,

    Thanks for your reply.I am attaching an image.I am getting an error while compiling the code.Quick reply would be appreciated.

    Thanks,
    Narayana
    May be i made a mistake. why you have the 'connect' item?
    Is the username an oracle db user or your application system user?
    IF the username is an oracle db user please reference the logon procedure in the form builder help.
    IF the username is your application system user you must replace the ':loginid' with your item ':username'.
    hope you can understand me, my english is poor ......

  5. #5
    Join Date
    Apr 2010
    Posts
    30
    Thanks for your reply.

    May be i made a mistake. why you have the 'connect' item?

    This is for other testing purpose,we are using only the username and pwd fields

    Is the username an oracle db user or your application system user?

    Username is to be retreived from the Oracle DB table.So I guess it is an oracle db user.

    IF the username is an oracle db user please reference the logon procedure in the form builder help.

    Sorry I am yet to work on the logon procedure.I have not created any procedures.Is there any site that I can reference to get same codes?.I have just started learning forms and reports.Have basic working knowledge of PL/SQL.

    Thanks

  6. #6
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,013
    Quote Originally Posted by narayanyr View Post
    I am getting an error while compiling the code.
    A semi-colon is missing in DECLARE section. Should be
    Code:
    v_exist varchar2(1);

  7. #7
    Join Date
    Apr 2010
    Posts
    30
    Thanks.The error is resolved but the other 2 bind variable errors exist.How do I connect to the DB?

  8. #8
    Join Date
    Nov 2010
    Posts
    3
    Quote Originally Posted by narayanyr View Post
    Thanks.The error is resolved but the other 2 bind variable errors exist.How do I connect to the DB?
    WHERE loginid = :username
    AND Password = :Password;

  9. #9
    Join Date
    Jul 2012
    Posts
    3
    I am just a novice and Oracle Forms was not being taught in school be we need to create a working prototype for our Oracle database and my problem was to create a user log in program where in if a user has an account he could log in but if he/she does not have he/she will be trying to register for a new account.T hank you so much

  10. #10
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,435
    If you don't specify a login against the database when you invoke the form, it will open a login screen and ask you for username, password, and SID to login as an oracle user.
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

  11. #11
    Join Date
    Jul 2012
    Posts
    3
    I already did it and it was successful. All I need is how to create an Oracle Form program that asks the users' username and password if he/she has an account then he/she will be login saying you successfully login or if he/she does not have an account he/she will have to register for an account. Thanks again.

  12. #12
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,658
    does below reasonably reflect you situation?

    EndUser<=>browser<=>WebServer<=>ApplicationServer< =>DatabaseServer
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    There are no stupid questions, but there are a LOT of Inquisitive Idiots.

  13. #13
    Join Date
    Jul 2012
    Posts
    3
    Oh is that so, I am very sorry but that is the specification/instruction given by our Teacher and I could not dare to break that number one rule of using Oracle Form, Mister.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •