Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2016

    Exclamation Unanswered: How to make a Logon screen in Oracle forms where userid and pwd is based on table.


    My question is how can I make a Logon form/screen in Oracle forms validated by the data in my table inside the database. Also I need to call another form/window after successfully login. Thanks.

  2. #2
    Join Date
    Jan 2004
    Croatia, Europe
    Provided Answers: 5
    As far as I can tell, FIRST you have to connect to the database. THEN you can validate whatever you want. So, I believe that you can't avoid Oracle username/pasword@database connection, but you can - afterwards - force users to apply some additional credentials.

    That is (or should I say "was") used when you're lazy to create as many Oracle users as necessary and want to make things simpler for you by creating your own "users" table. In my opinion, you should stick to database users.

    As of your next question: there are 3 built-ins used to call other forms: CALL_FORM, OPEN_FORM and NEW_FORM. Read more about tem in Forms Online Help System.

Tags for this Thread

Posting Permissions

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