Home » Developer & Programmer » Forms » URGENT: problem in logon screen.
URGENT: problem in logon screen. [message #209679] Sat, 16 December 2006 13:38 Go to next message
Messages: 74
Registered: October 2006
Location: Pakistan

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

SQL> conn system/manager
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.

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.

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


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

Report message to a moderator

Re: URGENT: problem in logon screen. [message #209792 is a reply to message #209679] Sun, 17 December 2006 20:54 Go to previous message
Messages: 10180
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
What was wrong with http://www.orafaq.com/forum/m/201872/67467/?srch=login#msg_201872

Previous Topic: How to Remove Title Bar In Forms 6i
Next Topic: check box and record insertion problem!
Goto Forum:

Current Time: Sun Aug 20 18:14:29 CDT 2017

Total time taken to generate the page: 0.10266 seconds