OAS & User Authentication / Logon

We are building an application using Oracle8i + OAS 4.0.7 /4.0.8 using the PL/SQL cartridge.

Each user who logs in will have an Oracle Username/Password. We need to do the following:

1. Display a logon screen to accept the username/password 2. Log to Oracle using this 3. If invalid username/password, show error screen 1 4. If password expired, show error screen 2 5. Otherwise, show the application main screen. This is generated by PL/SQL and is available to the users.

What is the best way to go about doing this? Can you also include some code-samples?

TIA. Anup.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Nov 30 1999 - 07:59:58 CST