OraFAQ Forum: Forms » URGENT: problem in logon screen.

Home » Developer & Programmer » Forms » URGENT: problem in logon screen.

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

URGENT: problem in logon screen. [message #209679]

Sat, 16 December 2006 13:38

lunate
Messages: 74
Registered: October 2006
Location: Pakistan

Member

hi all.
i want to bypass Oracle login screen or customise it by displaying my own logon screen.As

SQL> conn system/manager
Connected.
SQL> declare
2 uname varchar2(10);
3 pass varchar2(10);
4 begin
5 uname := 'lunate';
6 pass :='sun';
7 logon(uname, pass||'@orcl');
8 end;
9 /

but i got the following errors.

Quote:

logon(uname, pass||'@orcl');
*
ERROR at line 7:
ORA-06550: line 7, column 6:
PLS-00201: identifier 'LOGON' must be declared
ORA-06550: line 7, column 6:
PL/SQL: Statement ignored

and also i want to display my own logon screen in oracle form 6i ,can some one tell me the proper way to write a pl/sql code in forms to do this.
when i put this code in my form with two text fields >>
user name,password,, and also put this code at the 'when-button-pressed' trigger of a button under these text field.but when i run it, it ask me to first log-in then run the form.
(hope u got my point.)

please tell em proper methodz to make logon screen in both database+form 6i.

Quote:

i also search this form for 'login screen' ,but i got in-sufficient help form this search.

regars.

[Updated on: Sat, 16 December 2006 13:42]

Report message to a moderator