-
Not_logged_on Error
Hello
For not NOT_LOGGED_ON error the explanation is as follows.
Raised if your PL/SQL Program issue a database call without being logged on to oracle.
How can we issue a PL/SQL program without logged on to oracle? Give me one example when does it arises?
Regards
Babi
-
Re: Not_logged_on Error
The main cause of this is time out.
It mainly arises when the connection s timed out or got disconnected in the middle of a program execution.
-
Re: Not_logged_on Error
Hi babi,
Check here U will get good idea
[url]http://www.itk.ilstu.edu/docs/Oracle/appdev.101/b10807/07_errs.htm[/url]
Byee sudheer
-
Re: Not_logged_on Error
The Best example you can see while running a procedure, when oracle stops after giving u the message "ORA-12170: TNS:Connect timeout occurred".
That procedure should contain the
Exception
when NOT_LOGGED_ON then
----statemnet which give u any message;
You can check whether the Exception went to the handler or not.