If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > Oracle > Oracle forms Login Screen

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old
Registered User
 
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
Reply With Quote
  #2 (permalink)  
Old
Registered User
 
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;
******************************
Reply With Quote
  #3 (permalink)  
Old
Registered User
 
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
Oracle forms Login Screen-error.jpg  
Reply With Quote
  #4 (permalink)  
Old
Registered User
 
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 ......
Reply With Quote
  #5 (permalink)  
Old
Registered User
 
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
Reply With Quote
  #6 (permalink)  
Old
Lost Boy
 
Join Date: Jan 2004
Location: Croatia, Europe
Posts: 3,984
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);
Reply With Quote
  #7 (permalink)  
Old
Registered User
 
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?
Reply With Quote
  #8 (permalink)  
Old
Registered User
 
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;
Reply With Quote
  #9 (permalink)  
Old
Registered User
 
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
Reply With Quote
  #10 (permalink)  
Old
Lead Application Develope
 
Join Date: Jun 2004
Location: Liverpool, NY USA
Posts: 2,412
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.
Reply With Quote
  #11 (permalink)  
Old
Registered User
 
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.
Reply With Quote
  #12 (permalink)  
Old
Registered User
 
Join Date: Aug 2003
Location: Where the Surf Meets the Turf @Del Mar, CA
Posts: 7,571
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.
Don't say, show. Don't promise, prove.
Reply With Quote
  #13 (permalink)  
Old
Registered User
 
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.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On