Printable View
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
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.
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
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.