iam new to pl/sql server pages. Here i have a login page which has username and password. but the user must be valid database user.
here i want to write a stored procedure which checks whether the user is valid or not. The details are as follows.
input values are username and password. we have to check this values to database table with name profile.if it is true then return a flag.
guys can you help me in this aspect.
create or replace procudure check(username IN varchar2,password IN varchar2)
create a cursor which will get the username and password from the database based on the username passed into the procedure and open the cursor then assigned them to variables. Just do a simple compare on the two values then