Re: Error ORA-3113

Hi,

u might have a look at the dump file in the udump destination (see init<sid>.ora or config<sid>.ora or ask your DBA. Sometimes the cause for the interrupt is listed there and if not u find a cursor dump at the end of the file. Check the last cursor, it should cause the interrupt, if it is not due to exceeding the time limit.

HTH,
Ansgar

Maite Alvarez wrote:
>
> I have some problems with a Pro*C program.
> This program is installed in a PC computer running SCO Unix v 3.0 and ORACLE
> 7.0.15.
>
> At the beginning, the program connects to the database correctly and begins to
> select data from the DB. After some minutes, the program detects the ORA-3113
> error (end of communication channel).
> I don't use SQLNet.
>
> I compile and link my program in another computer with the same version of
> operating system and ORACLE. In this computer the problem don't arise.
>
> I would appreciate any help you could give me.
>
> Thank you very much.
 

-- 
 Ansgar Seiter          	 Group Prof. Ch. Schlier      
 Department of Physics  	                             
 University of Freiburg 	 Phone:  +49 761 203-5730      
 Hermann-Herder-Str. 3  	 FAX:    +49 761 203-5873            
 D-79104 Freiburg i.Br  	 E-Mail: ansgar.seiter_at_physik.uni-freiburg.de 
 Germany