ORA-02396

From: D S Tharpe <i5t_at_ornl.gov>
Date: Tue, 04 Aug 1998 15:03:01 -0400
Message-ID: <35C75AE5.41C67EA6@ornl.gov>

ERROR: Oracle COMMIT Error: ORA-02396: Unable to open message file

(SQL-02113). ORA-02396: exceeded maximum idle time, please connect again

This ORACLE error is occurring in SQL embedded in a SAS program. (SUN OS/UNIX environment)

If a user's idle and connect time are set to unlimited, why would they get this message? 100,000 rows were being updated, and the message prior to this message is '100000 rows were updated'. What other reasons would cause this to occur?

Any help appreciated,

D. Tharpe (i5t_at_ornl.gov) Received on Tue Aug 04 1998 - 14:03:01 CDT