| URGENT: problem in logon screen. [message #209679] |
Sat, 16 December 2006 13:38  |
|
|
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 |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
