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
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

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

David
Previous Topic: How to Remove Title Bar In Forms 6i
Next Topic: Failed to open file:ifrun60_dump_3936
Goto Forum:
  


Current Time: Fri Dec 09 09:35:46 CST 2016

Total time taken to generate the page: 0.11563 seconds