This discussion is archived
1 2 3 Previous Next 42 Replies Latest reply: Feb 22, 2013 5:07 PM by 992059 RSS

Login Screen in Oracle forms builder 6i

992059 Newbie
Currently Being Moderated
Hello everyone

I am trying to create a canvas with a login screen and password in oracle forms builder 6i.

So far I have create the following table:

CREATE TABLE PASSWORD
(USER_ID NUMBER(3)
CONSTRAINT PASSWORD_USER_ID_PK PRIMARY KEY,
PASSWORD VARCHAR2(20) NOT NULL);

Inserted the following values:

INSERT INTO PASSWORD (USER_ID,PASSWORD)
VALUES (1,1010);

INSERT INTO PASSWORD (USER_ID,PASSWORD)
VALUES (2,2020);

Created a MENU canvas with a LOGIN button TI_USER_ID and TI_PASSWORD text boxes.
In the LOGIN button i have inserted the following WHEN-BUTTON-PRESSED trigger:

BEGIN
SELECT USER_ID
INTO :GLOBAL.USER_ID
FROM PASSWORD
WHERE USER_ID = :LOGIN.TI_USER_ID
AND PASSWORD= :LOGIN.TI_PASSWORD;
GO_BLOCK('PASSWORD');
EXCEPTION
WHEN NO_DATA_FOUND THEN
:GLOBAL.COUNT := :GLOBAL.COUNT + 1;
IF :GLOBAL.COUNT = 1 THEN
MESSAGE('wrong');
MESSAGE('wrong');
ELSIF
:GLOBAL.COUNT = 2 THEN
MESSAGE('wrong');
MESSAGE('wrong');
ELSIF
:GLOBAL.COUNT = 3 THEN
EXIT_FORM;
END IF;
END;

When i try to compile that it gives an error Bad bind variable LOGIN.TI_USER_ID
Bad bind variable LOGIN.TI_PASSWORD

What am i doing wrong?
1 2 3 Previous Next

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points