Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: 'Orphaned' user processes
> > FROM: Tom Morris - Kimball International, Inc. (812) 482-8263
> > Information Systems USKIMNVM_at_IBMMAIL.COM
> >
> SUBJECT: 'Orphaned' user processes
>
> We've got an application using SQL*FORMS 3.0 on HP-UX 9.0.4 and the
> users access it from their PC by logging on to Unix. For various
> reasons, such as when a network problem occurs, or a power outage
> occurs, or user error, these users become disconnected from the network
> and from Oracle and HP-UX, but their sessions still exist on our HP server.
...
Try wrapping the SQL*Forms session in a C shell script. Use the onintr command to trap and exit the session. I've creating applications using this technique in a similar environment to yours without any problems at all.
Jack