Re: ISQL*PLUS SESSION PROBLEM

Rui Cunha wrote:

>Hi daniel,
>thanks for your post...this is the error msg that we receive:
>
>SP2-0864 Session has expired. Please log in again
>
>PS1: we're using oracle 9.0.1 release...
>PS2: hope this is more helpful :)
>
>Best Regards,
>
>Rui
>
>Daniel Morgan <damorgan_at_x.washington.edu> wrote in message news:<1066831473.438552_at_yasure>...
>
>
>>Rui Cunha wrote:
>>
>>
>>
>>>Hi,
>>>
>>>i'm having some problems at work with isql*plus in what concerns with
>>>session timeouts...
>>>
>>>here is the scenario:
>>>a class with 30/40 students working on PL/SQL and requesting the
>>>database server for info.no client installation was made...they only
>>>use the isqlplus tool via browser...
>>>
>>>now for the problems:
>>>
>>>problem1: after a couple of minutes, they start receiving "session
>>>expired" messages...when they loggin again they face the 2nd problem:
>>>
>>>problem2: some of them loose all data commited before the session
>>>expire....
>>>
>>>i tried to resolve problem1 editing isqlplus.conf file at the server
>>>and setting session timeout parameter to OFF...no lucky....
>>>
>>>i wonder if problem2 is related with problem1...
>>>
>>>if any1 could help me out i'd be ver thankfull.
>>>
>>>Thanks for all of your attention.
>>>
>>>Best Regards,
>>>
>>>Rui
>>>
>>>
>>>
>>>
>>It is not possible to help you with what you posted. Your interpretation
>>of an error
>>message is not helpful. Please post the actual error messages.
>>
>>
I don't recognize the message as an Oracle error and can find no [Quoted] reference to it on metalink.

I'd suggest looking elsewhere for whatever is generating the message.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)