-
Contributing Member
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.
-
Junior Member
Re: Not_logged_on Error
Hi babi,
Check here U will get good idea
http://www.itk.ilstu.edu/docs/Oracle...07/07_errs.htm
Byee sudheer
-
Junior Member
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.
Last edited by satya_vinayan; 03-04-2008 at 07:26 AM.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules